CODEWITHSUNDEEP
mysqlsearchindexingfulltext-index
navidoo
navidoo

Reputation: 309

MySQL Fulltext index search returns wrong results

I have a MyISAM table with a Fulltext index on the NAME column which is VARCHAR(200). I'm searching the table using the Boolean mode and I'm getting very strange results. Example: Let's look for records with the word "TRULY" in the NAME column:

select * from table_MYISAM WHERE MATCH(NAME) AGAINST('+TRULY' IN BOOLEAN MODE);

This returns no results. Now let's look for both "TRULY" and "RICHARD":

select * from table_MYISAM WHERE MATCH(NAME) AGAINST('+TRULY +RICHARD' IN BOOLEAN MODE);

This query returns hundreds of thousands of records with "RICHARD" in NAME, but none contain "TRULY". What is going on?

Upvotes: 0

Views: 209

Answers (1)

Mihai
Mihai

Reputation: 26784

If you look at the list for myisam stop words,truly is in there.Scroll further down.You can use an empty file if you dont want any stop words or edit the existing one.

Upvotes: 1

Related Questions