mysql - php mysql 按相关性排序全文搜索

Question

如何按相关性进行全文搜索？

SELECT * FROM table
WHERE MATCH (col1,col2,col3) 
AGAINST ('+$boolean' IN BOOLEAN MODE)
Order By relevance

我要设置相关性，首先要匹配col1, col2，然后匹配col3，如果col1, col2完成则更多单词匹配，然后输入col3。

也许我应该设置一个百分比，例如 col1, col2 的相关性为 66%，col3 的相关性为 34%...

Answer 1

你可以尝试这样的事情:

SELECT *, (MATCH(col1, col2) AGAINST('+$boolean' IN BOOLEAN MODE) * 0.66 + MATCH(col3) AGAINST('+$boolean' IN BOOLEAN MODE) * 0.34) AS relevance
FROM table
WHERE MATCH(col1, col2, col3) AGAINST ('+$boolean' IN BOOLEAN MODE)
ORDER BY relevance DESC