MySQL Forums
Forum List  »  MyISAM

fulltext boolean search not returning a particular row
Posted by: Sascha Monteiro
Date: August 31, 2012 10:03PM

I have a record containing "Do You Still Think of Me" (the table has about 2700 records),
and the following query does not return the record;
SELECT * FROM productions
WHERE MATCH (title) AGAINST ('+Do +You +Still +Think +of +Me' IN BOOLEAN MODE)
(neither with the + removed, or less keywords)
The rest of the table seems to be returned okay on their keywords, just not this record.
The ft min word length is 4, but should still return if I query on +Still +Think
MySql version is 5.0 (this is hosted, can't upgrade..)
there is a fulltext index on title, and the engine is MyIsam
I repaired and optimized the table, dropped and recreated the fulltext index, no luck :-(

Any pointers?

Options: ReplyQuote

Written By
fulltext boolean search not returning a particular row
August 31, 2012 10:03PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.