MySQL 全文搜索总是有 0 个结果？

Question

我读到使用全文搜索比使用 LIKE %% 更快。我已经更新了我的脚本，但它似乎总是有 0 个结果。

SELECT *,
MATCH(pages) AGAINST('doodle') AS score
FROM books
WHERE MATCH(pages) AGAINST('doodle')
ORDER BY score DESC 

$关键字长于 4 个字符，我已将页面列索引为全文。我在“洋基涂鸦”格式的页面列中有“涂鸦”。

这个我也试过

SELECT *,
MATCH(pages) AGAINST ('doodle' IN BOOLEAN MODE) AS score 
FROM books 
WHERE MATCH(pages) AGAINST ('doodle' IN BOOLEAN MODE)"; 

它们都不起作用:\

Answer 1

全文搜索有一些奇怪的怪癖。

例如，this page 的最后一段中描述的行为可能是您遇到问题的原因:

.... for example, although the word “MySQL” is present in every row of the articles table shown earlier, a search for the word produces no results:

mysql> SELECT * FROM articles
    -> WHERE MATCH (title,body) AGAINST ('MySQL');
 Empty set (0.00 sec)

The search result is empty because the word “MySQL” is present in at least 50% of the rows. As such, it is effectively treated as a stopword. For large data sets, this is the most desirable behavior: A natural language query should not return every second row from a 1GB table. For small data sets, it may be less desirable.

此处的答案是添加更多行，或使用 bool 搜索。

如果您需要加权搜索结果，请查看链接页面上的评论 John Craig 于 2009 年 12 月 16 日晚上 7:01 发表，以获得解决方法建议。