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
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
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
'Words' shows in more than 50% rows will be regards as a stop words.
2009/4/24 mysupp...@asuma.com
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
Sorry, I don't understand your answer. Could you kindly explain in more details?
Thanks,
Jack
--- On Fri, 4/24/09, zhu dingze mysql.li...@gmail.com wrote:
From: zhu dingze mysql.li...@gmail.com
Subject: Re: Full Text Search Problem
To: mysupp...@asuma.com
Cc: mysql
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
and
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
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 a dbase for lost pets.
My problem is the following:
I have dog
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 text search problem
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
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 a
11 matches
Mail list logo