RE: "Match" does not find it, but "Like" finds it

2001-05-28 Thread Chris Bolt
>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

"Match" does not find it, but "Like" finds it

2001-05-28 Thread Marc Delisle
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