Full text error.
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.
Subject
Views
Written By
Posted
Full text error.
3653
January 31, 2010 01:09PM
2290
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.