>From http://www.mysql.com/doc/F/u/Fulltext_Search.html:
mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('MySQL');
Empty set (0.00 sec)
Search for the word MySQL produces no results in the above example. Word
MySQL is present in more than half of rows, and as such, is effectively
Hi,
Using MySQL 3.23.38, I have a table with a mediumtext field "contenu" and a fulltext
index on it.
The
field contains full HTML documents.
The following command usually works to find words:
select titre from sites where match(contenu) against ('virus')
The problem is, some words, like "Ne