Welcome to TDBSoverflow, Our class's own StackOverflow. Our rules:
  1. Use only meaningful and self-explanatory titles
  2. Tag your questions with meaningful keywords
  3. Use upvotes and downvotes to rate the answers
  4. When you receive a satisfying answer - Click the "V" button
Remember: you may get up to 5 bonus points to your final grade!

Zero scoring for FULL TEXT Search in NATURAL LANGUAGE MODE

+5 votes
54 views
Hi,

We've created a Lyrics table as Amit suggested on the following post:

http://courses.cs.tau.ac.il/0368-3458/forum/index.php?qa=191&qa_1=full-text-search-in-inodb

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?

Thanks
asked Jan 15, 2018 by Yossielman (990 points)

1 Answer

+5 votes
 
Best answer
I found this very helpful for understanding the usage of NATURAL LANGUAGE MODE:

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

Reffering your question, please check the box in blue in the bottom of the page, titled 'MyISAM Limitation'.

Hope this helps.
answered Jan 15, 2018 by Assaf (31,090 points)
selected Jan 16, 2018 by Yossielman
Thanks!
The problem was we tested it without enough data.
...