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
'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
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
Hi Pieter,
That's because "may" is a stopword in MySQL's full-text indexing, by
default (like "can," "the," etc). You can define your own stopword file
with the ft_stopword_file variable. And you can find the default, built-in
list of stopwords in the file myisam/ft_static.c of the source
distri
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.
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