No Match Against 'test'

[Mike McKee]

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?