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.
I know that Dreamhost is using MySQL 3.23.55 and perhaps this is a bug in that version.
Any help would be appreciated. Thanks!