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, 20

Re: Full Text Search Problem

2009-04-24 Thread zhu dingze
'Words' shows in more than 50% rows will be regards as a stop words. 2009/4/24 > 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), DEPA

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

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

RE: Full text search problem

2004-06-21 Thread Paul McNeil
crit_results); God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -Original Message- From: Terry Riley [mailto:[EMAIL PROTECTED] Sent: Monday, June 21, 2004 5:08 AM To: [EMAIL PROTECTED] Subject: Re: Full

Re: Full text search problem

2004-06-21 Thread Matt W
he file myisam/ft_static.c of the source distribution. Hope that helps. (Oh, also what Terry said in his reply!) Matt - Original Message - From: "Pieter Botha" Sent: Monday, June 21, 2004 3:54 AM Subject: Full text search problem > Hi > > I have a fulltext search on

Re: Full text search problem

2004-06-21 Thread Terry Riley
Pieter, I think FTS minimum WORD size is 4 characters - you may to be searching with 3 on 'May May'. Not having ever used FTS; I believe you can adjust it to count 3-character words by changing the configuration, but I'm not sure where - and it would then need re-indexing, if I'm not mistaken.

Full text search problem

2004-06-21 Thread Pieter Botha
Hi I have a fulltext search on a dbase for lost pets. My problem is the following: I have dog in the database called "May May" which doesnt show up in the search results. A dog called "Doggy Doggy" does show up however. I guess the problem is that MySql sees "May May" as being a date or something

Re: full-text search problem

2001-09-26 Thread Arjen G. Lentz
Hi Anton, - Original Message - From: "Tichawa Anton" <[EMAIL PROTECTED]> > I have problems with full-text search. My table contains text lines from > computer-generated log files rather than documents written by humans, > and so my first problem is that I need an exact match rather than

full-text search problem

2001-09-26 Thread Tichawa Anton
Hi, I have problems with full-text search. My table contains text lines from computer-generated log files rather than documents written by humans, and so my first problem is that I need an exact match rather than a relevance value, i. e. if the search string is 'ai', I really need all rows conta