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. :-)
Also, key_len of 0 in EXPLAIN is normal. It sounded like you are getting some kind of error in your first message? If so, what is it? Are you SURE that the EXACT word you're searching for is present in the table (for example, with a space, etc. on either side of it)? Matt ----- Original 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 > 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]> > >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! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
