Sorry, I don't understand your answer. Could you kindly explain in more details?
Thanks, Jack --- On Fri, 4/24/09, zhu dingze <[email protected]> wrote: From: zhu dingze <[email protected]> Subject: Re: Full Text Search Problem To: [email protected] Cc: [email protected] Date: Friday, April 24, 2009, 5:57 PM 'Words' shows in more than 50% rows will be regards as a stop words. 2009/4/24 <[email protected]> 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/[email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
