PHP MySQL过滤相关内容中的内容值 - PHP MySQL filter content value in related content

PHP MySQL filter content value in related content

本文关键字：MySQL 过滤 PHP | 更新日期: 2023-09-27

我使用这个函数搜索相关的标题:

$related = Access::FETCH("SELECT title, MATCH(title) AGAINST('".$DB_QUERY[0]['title']."') AS score
                FROM " . SONGS . "
                WHERE MATCH(title) AGAINST('".$DB_QUERY[0]['title']."') 
                ORDER BY score DESC LIMIT 5");
foreach($related as $row){
   echo $row['title'];
}

ie:

//search title clapton
 $DB_QUERY[0]['title'] = 'clapton'; 
//result
clapton // same title
eric clapton 
clapton song
clapton guitar

这对我有用，但在结果搜索和打印相同的标题+其他标题。我怎样才能找到相关的标题没有显示相同的标题?

可以使用

"SELECT title, MATCH(title) AGAINST('".$DB_QUERY[0]['title']."') AS score
            FROM " . SONGS . "
            WHERE MATCH(title) AGAINST('".$DB_QUERY[0]['title']."') 
            and title <> '".$DB_QUERY[0]['title']."'
            ORDER BY score DESC LIMIT 5"