List:General Discussion« Previous MessageNext Message »
From:mysupport Date:April 24 2009 6:16am
Subject:Full Text Search Problem
View as plain text  
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




Thread
Full Text Search Problemmysupport24 Apr