fulltext boolean search not returning a particular row
Hi,
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?
Subject
Views
Written By
Posted
fulltext boolean search not returning a particular row
2509
August 31, 2012 10:03PM
1404
September 01, 2012 06:14PM
1473
September 01, 2012 09:44PM
1589
September 02, 2012 06:01PM
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.