Don Dikunetsis [EMAIL PROTECTED] wrote:
Hi,
The comments in the fulltext doc page
(http://www.mysql.com/doc/en/Fulltext_Search.html) discuss the issues of
stopwords and over 50% hits, so I did my best to avoid those particular
bombs in my searches.
The subject column contains
W [EMAIL PROTECTED]
To: Don Dikunetsis [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: fulltext search always returns no results
Date: Thu, 26 Feb 2004 01:26:17 -0600
Hi Don,
No, full-text search was added in MySQL 3.23.23, I believe (4.0.1 just
added boolean searches along with more speed
Lovatt [EMAIL PROTECTED]
To: Matt W [EMAIL PROTECTED], Don Dikunetsis
[EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: fulltext search always returns no results
Date: Thu, 26 Feb 2004 07:57:21 -
Hi
Full text can have some strange results.
It ignores common words, like the, if, and, etc
Summary: When I run a fulltext search, it always returns no results. I have
added a fulltext index to the column being searched. Also, I am searching
for a term that is in the table, but not in more than 50% of the rows.
I notice that when I add EXPLAIN to my search, the key_len of my fulltext
Excuse if i'm not correct but this may be your problemo ?
MySQL 3.23.55 running on my webhost's Linux box
phpMyAdmin 2.1.0
I didnt think fulltext was in 3.23 wasnt this a Mysql 4 feature ??
Summary: When I run a fulltext search, it always returns no results. I
have added a fulltext index
of this won't work with your configuration--my
setup certainly doesn't seem to be responding to the normal setup
instructions for fulltext search.
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: fulltext search always returns no results
Date: Thu, 26 Feb 2004 10:12:42
to be responding to the normal setup
instructions for fulltext search.
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: fulltext search always returns no results
Date: Thu, 26 Feb 2004 10:12:42 +1100 (EST)
Excuse if i'm not correct but this may be your problemo
-
From: Don Dikunetsis
Sent: Thursday, February 26, 2004 12:21 AM
Subject: Re: fulltext search always returns no results
Hi, thanks for your reply, but it looks like:
As of Version 3.23.23, MySQL has support for full-text indexing and
searching.
--according to:
http://www.mysql.com
Hi Don,
No, full-text search was added in MySQL 3.23.23, I believe (4.0.1 just
added boolean searches along with more speed overall). It doesn't need
to be compiled in or anything, it's there by default. Unless someone
compiled it and actually *removed* the full-text code or something. :-)