mysql fulltext returns zero results even though the exact search phrase exists in the table

I have a table called myatts :

• It has about 3,332,834 rows of data.

• I generally search the column "content"

• I have about 40 rows where content = Rat, D.D.

However when I fulltext search for it I get no results. But if I use LIKE I do get the results.

I want to stick with fulltext, can anyone help me figure out why there are no results returned?

He开发者_高级运维re is my table structure:

id  
int(11) Not null AUTO_INCREMENT

join_id     
int(11) Not Null

webid
int(11) Not Null 

content
text utf8_general_ci

Here are my indexes

Keyname Type      Unique Packed      Field      Cardinality
PRIMARY BTREE     Yes    No      id             3332834     
content BTREE     No     No      content (333)  238059          
id_index    BTREE     No     No      webid      151492          
join_id BTREE     No     No      join_id        36          
content_ft  FULLTEXT  No     No      content        119029

Here is my query:

SELECT * FROM myatts WHERE MATCH(content) AGAINST('Rat, D.D.' IN BOOLEAN MODE)

Here is the explain:

1   SIMPLE  myatts  fulltext    content_ft  content_ft  0       1   Using where

Any help/pointers would be great. Thanks!

Your minimum word length is probably set to 4. Check the MySQL Manual for details..

By default MySQL's fulltext indexer ignores words that are fewer than 4 characters in length. In your my.cnf set this variable:

ft_min_word_len=3

I you probably don't want to go less than 3 because you'll end up with false positives.