Full Text Search Problem

2009-04-23 Thread mysupport
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

Full Text Search Problem

2009-04-23 Thread mysupport
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

Full Text Search Problem

2009-04-24 Thread mysupport
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

Re: Full Text Search Problem

2009-04-24 Thread mysupport
Sorry, I don't understand your answer. Could you kindly explain in more details? Thanks, Jack --- On Fri, 4/24/09, zhu dingze wrote: From: zhu dingze Subject: Re: Full Text Search Problem To: mysupp...@asuma.com Cc: mysql@lists.mysql.com Date: Friday, April 24, 2009, 5:57