'Words' shows in more than 50% rows will be regards as a stop words.
2009/4/24 <mysupp...@asuma.com>
> Hi,
>
> I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
>
> 'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
> ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF
> COMMERCE'.
>
> When I did a search like the following;
>
> SELECT COUNT(*) FROM article WHERE MATCH (agency) AGAINST ('DEPARTMENT OF
> COMMERCE');
>
> It returned count(*) = 0 instead of count(*) = 6.
>
> Could you kindly advise me what did I do wrong?
>
> Thanks,
>
> Jack
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=mysql.li...@gmail.com
>
>
