1

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 ;
1

I found the solution. Thanks Anyways

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

The search result is empty because the “search word” is present in at least 50% of the row entries, and so is effectively treated as a stopword.

my solution was to add more db entries so that the search term is less than 50% of the of the rows values.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.