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 "Netscape" or "Windows", are never found
with MATCH. Other words of the same length are found.
However, if I use a LIKE, they are found:
select titre from sites where contenu like '%Netscape%'
I did not see those words that don't work, in the stopword list myisam/ft_static.c
--
Marc Delisle
Service de l'informatique
Collège de Sherbrooke, Québec
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
