CODEWITHSUNDEEP
mysqlsearchfull-text-search
Olizt
Olizt

Reputation: 161

Full text search with a very simple MySQL statement

I recently came across a wierd issue with MySQL Fulltext search. My statement is really simple: 

SELECT * FROM `mytable` WHERE MATCH (`desc`) AGAINST ('+NOR +710' IN BOOLEAN MODE)

And this is what in the desc column: "The NOR 710 also has smoke seal ..."

For some reason it won't find that row. I added Fulltext index to that column, mysql version is 5.1.56 , database engine of that table is MyISAM. Is there anything else i need to check?

Thanks

Upvotes: 0

Views: 86

Answers (1)

Kaivosukeltaja
Kaivosukeltaja

Reputation: 15735

By default, fulltext indexes will ignore words that are shorter than 4 charaters. Adjust your ft_min_word_len to also include the shorter words.

Upvotes: 3

Related Questions