i think u have to compile it in as an option, it doesnt as default, i wouldnt be suprised if Mysql 4 did a better job though, trying to convince work to upgrade all machines to Mysql 4 hopefully 4.1 is a task in itself.
> > 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/doc/en/Fulltext_Search.html > > However, I would be unsurprised (though disappointed) to find that the > answer is some variant 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 +1100 (EST) >> >>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 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 index is 0. Does that mean my fulltext index is empty, >> > explaining why my searches never return any results? >> > >> > Either way, I'd be grateful for any suggestions on how to get >> > fulltext search to work! > > _________________________________________________________________ > Get a FREE online computer virus scan from McAfee when you click here. > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
