mysql - 仅查找与 FULLTEXT 索引完全匹配的内容

Question

我有一个包含短语的表格:

buy car
adopt cute cat
make big money
buy helicopter
big nasty dog

上面有全文索引。我想找到给定文本中完全出现的所有短语。

对于文本:

I want to buy car and then buy and adopt cute cat tomorrow.

我应该得到:

buy car
adopt cute cat

我尝试查询:

SELECT * FROM `phrases` WHERE MATCH(`phrase`) AGAINST('I want to buy car and then buy and adopt cute cat tomorrow.' IN BOOLEAN MODE)=`numWords`

但这给了我

buy helicopter //since there are twice "buy" and the number of total words is 2
adopt cute cat 

提前致谢。

Answer 1

只需在您的查询中添加AND 短语，例如“%I Want to buy car and then buy and领养可爱的猫明天。%”。它将使用 FULLTEXT 键快速查找匹配项，然后对结果进行后过滤以确保短语列中存在准确的短语。