全文match()对()返回空集 [英] Fulltext match() against() returning empty set

问题描述

我有一个全文索引表，其中装有数据系列.没有空格，并且拼写正确.如何使此查询与得分匹配，并按DESC顺序按得分显示结果?我不停地坐着，不知道为什么.

I have a full text indexed table set up with the data Family in it. There is no White Space and the spelling is correct. How can I make this query match results as score and display them by score in DESC order? I keep getting empty set and don't know why.

 SELECT *, MATCH(MEDIA_TITLE) AGAINST('Family') AS SCORE FROM MEDIA_DATA_VIDS WHERE MATCH(MEDIA_TITLE) AGAINST('Family') ORDER BY SCORE DESC ;

非常感谢您的帮助.

推荐答案

请参见 https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html :

搜索结果为空，因为至少有50％的行中包含"MySQL"一词，因此实际上被视为停用词.

The search result is empty because the word "MySQL" is present in at least 50% of the rows, and so is effectively treated as a stopword.

因此，您需要搜索其他单词.但不要选择其他停用词.

So you need to search for a different word. But don't pick another stop word.

这篇关于全文match()对()返回空集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！