MySQL Forums
Forum List  »  Full-Text Search

No Match Against 'test'
Posted by: Mike McKee
Date: August 27, 2008 06:39AM

I had this weird issue with MySQL MATCH/AGAINST syntax last night. I created the start of a mini-CMS with an articles table. I then did this:

ALTER TABLE articles ADD FULLTEXT(title, content);

Title is a varchar. Content is a text.

The table is a MyISAM table on MySQL Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486).

So then I stuck "test" into some of the titles, and again in some of the contents.

I then did:

SELECT * FROM articles WHERE MATCH (title, content) AGAINST ('test');

And guess what? I got zero results back. So then I switched it like so:

SELECT * FROM articles WHERE MATCH (title, content) AGAINST ('test' IN BOOLEAN MODE);

And now results come back. Any idea why this occurs?

Options: ReplyQuote

Written By
No Match Against 'test'
August 27, 2008 06:39AM

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.