php - 按相关性进行 boolean 全文搜索顺序似乎不起作用

Question

好的，我正在测试两个查询，它们产生完全相同的结果，这说明按相关性排序在这里似乎不起作用:

$query1 = "SELECT * FROM ads 
           WHERE 
             MATCH (title,description) AGAINST ('+".$query."' IN BOOLEAN MODE) 
             AND status='Active'";

$query2 = "SELECT *, 
             MATCH (title, description) AGAINST ('+".$query."' IN BOOLEAN MODE) 
               AS score 
           FROM ads 
           WHERE status='Active' AND 
             MATCH(title, description) AGAINST ('+".$query."' IN BOOLEAN MODE) 
           ORDER BY score desc";

Answer 1

还要确保指定返回结果的顺序。

ORDER BY desc, score DESC;