>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
treated as a stopword (that is, with semantical value zero). It is, really,
the desired behavior - a natural language query should not return every
second row in 1GB table.
So "Netscape" or "Windows" are in more than half of the rows.
> 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
---------------------------------------------------------------------
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
