"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 c
actually contains anything?
From: "Matt 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
arches still
return blank results.
I must admit that at this point I'm stumped!
From: "Peter Lovatt" <[EMAIL PROTECTED]>
To: "Matt W" <[EMAIL PROTECTED]>, "Don Dikunetsis"
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: fulltext se
> 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
riginal Message -
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
&
k 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: R
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
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
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
