CODEWITHSUNDEEP
mysqlindexingfull-text-indexing
Jonny
Jonny

Reputation: 1329

Fulltext match() against() returning empty set

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 ;

Any Help is Greatly Appreciated.

Upvotes: 1

Views: 202

Answers (1)

Bill Karwin
Bill Karwin

Reputation: 562871

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

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.

Upvotes: 1

Related Questions