[RESOLVED] FULL-TEXT Search Not working?

[godwheel]

Hello:

I'm doing a Full-Text search on MySQL. My table structure is as follows:

articleID,articleTitle,articleContent
articleContent is a FULL-TEXT Index.

There are about 70 articles some which contain the "keyword" example below. For some reason I'm getting ZERO rows returned and I'm not sure why.

I figured maybe my version of mysql was too old, but it is version 4.1.24 which according to the manual should support the following:

SELECT articleTitle FROM PressArticles WHERE MATCH (articleContent) AGAINST ('Miami');

However, it doesn't give back any results. I'm thinking I did something wrong in the query itself, but after 2 hours I just cant see what is wrong with it.

I'm trying to get the Titles of the articles that have the word Miami in the content.

Any help would be appreciated!

[bogu]

This is from mysql manual:

Such a technique works best with large collections (in fact, it was carefully tuned this way). For very small tables, word distribution does not adequately reflect their semantic value, and this model may sometimes produce bizarre results. For example, although the word “MySQL” is present in every row of the articles table shown earlier, a search for the word produces no results:
mysql> SELECT * FROM articles
-> WHERE MATCH (title,body) AGAINST ('MySQL');
Empty set (0.00 sec)
The search result is empty because the word “MySQL” is present in at least 50% of the rows. As such, it is effectively treated as a stopword. For large datasets, this is the most desirable behavior: A natural language query should not return every second row from a 1GB table. For small datasets, it may be less desirable.

you can read more about this here ...

[godwheel]

I read that and when I tried a less "common" word it did work. That is very weird. Thanks for your help!