mysql - 如何在mysql全文搜索中获取相关搜索？

Question

我想要确切的“果阿生产厂”的相关性。它还会产生包含 Goa 的任何内容。

SELECT * FROM `app_search` WHERE MATCH (`keywords`) AGAINST
("production house in goa" in boolean mode) 
order by MATCH (`keywords`) AGAINST ("production house in goa" in boolean mode)
desc, rank desc;

谢谢

Answer 1

删除旧表并使用关键字全文索引和以下查询重新创建可以解决问题。

SELECT *, MATCH (`keywords`) AGAINST
('software development in florida'
IN BOOLEAN MODE) AS score
FROM `ftextsearch` WHERE MATCH (keywords) AGAINST
('software development in florid'
IN BOOLEAN MODE) order by score desc,rank desc

查询还返回分数中搜索的相关性。