Return to Question

Removed scroll bar on code and "thanks"

Source Link

edited Mar 2, 2018 at 17:03

90.3k
30
424
663

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.

 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.

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

Source Link

asked Mar 2, 2018 at 16:27

Jonny

Fulltext match() against() returning empty set

 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.