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
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
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
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
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
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
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
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
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
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
11 matches
Mail list logo