MySQL Forums
Forum List  »  Full-Text Search

Full text error.
Posted by: Andy Edwards
Date: January 31, 2010 01:09PM

I'm can not get the fulltext search function to work properly in MySQL when I search for a phrase. For example, I have a fulltext index on the field title in the table biz. When I execute this simple select statement:

select biz_id,title from biz where match (title) against ("Jimmy World")

I get back records that have 'Jimmy' OR 'World' in the title instead of just titles with 'Jimmy World'. I have tried multiple variations of this based on the syntax in the MySQL online manual, with single quotes, double quotes, parens and plus symbols. And I've searched the MySQL mailing lists for some clue. No luck so far.

Options: ReplyQuote

Written By
Full text error.
January 31, 2010 01:09PM
February 07, 2010 01:32PM

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.