Full Text Search issue

[Randall Carlson]

I am somewhat new to MySQL and I'm current working on a project that is using version 4.0.20. The project requires me to have full-text functionality and I've been experiencing some oddities.

I've recently been developing some additional functionality where I am filtering a result of a full-text search by month and year. The index has been configured to include 3 letter words.

I am selecting on a column that is stored as varchar with a full text index in a table of approx 2,300,000+ rows. When I restrict by MAY XX it returns 0 hits.

SELECT * FROM message_archive WHERE MATCH (date_time) AGAINST ('"MAY 04"' IN BOOLEAN MODE);

But I know for a fact that there are MAY XX rows in the table, because when I change the query I get hits.

SELECT * FROM message_archive WHERE date_time LIKE '%MAY 04';

This only happens with the string month of MAY all others seem to work fine (APR, DEC, etc...).

Is there something I am missing here?