We've created a Lyrics table as Amit suggested on the following post:
There is an issue, that the MyISAM table doesn't respond well to NATURAL LANGUAGE MODE.
We have a row with lyrics that has 'The beautiful people' string in it.
Unfortunately the command:
SELECT songID, MATCH (lyrics) AGAINST ('The beautiful people' IN NATURAL LANGUAGE MODE)
gives score = 0.
if we try BOOLEAN MODE:
SELECT songID, MATCH (lyrics) AGAINST ('The beautiful people' IN BOOLEAN MODE)
we get score = 2.
We expect the user to input his natural language and afraid BOOLEAN MODE doesn't give the best results, when NATURAL MODE works really well (on out local DB with innoDB table)
does anyone has any suggestion?