全文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屋!