[RESOLVED] FULLTEXT doesn't work when a word is in 2+ columns

suntra

Hi,

I have a table that contains something like this :

id 	message_texte
1 	  	Ça fait quand même plusieurs mois que je me suis i...
2 	  	En fait, je ne crois pas que c'est pour nier. C'es...
3 	  	Woah, ton histoire m'a tenu les yeux ouverts.

I have defined a FULLTEXT Index key on message_texte

When I use this query...

SELECT * FROM messages
WHERE MATCH(message_texte) AGAINST('plusieurs')

... it return the first row (that is ok)

But then, when I use this one...

SELECT * FROM messages
WHERE MATCH(message_texte) AGAINST('fait')

It doesn't return any results when it should return 2 (the two first rows) contain the word "fait" !

Any ideas why ??

MySQL : 5.0.24a-community-nt
phpMyAdmin : 2.9.1
Text columns use utf8_swedish_ci

suntra

Ok, found it...

FULLTEXT indices are NOT supported in InnoDB tables.
MySQL requires that you have at least three rows of data in your result set before it will return any results.
By default, if a search term appears in more than 50% of the rows then MySQL will not return any results.
By default, your search query must be at least four characters long and may not exceed 254 characters.
MySQL has a default stopwords file that has a list of common words (i.e., the, that, has) which are not returned in your search. In other words, searching for the will return zero rows.
According to MySQL's manual, the argument to AGAINST() must be a constant string. In other words, you cannot search for values returned within the query.