Re: fulltext search always returns no results

2004-02-26 Thread Don Dikunetsis
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

RE: fulltext search always returns no results

2004-02-26 Thread Don Dikunetsis
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

Re: fulltext search always returns no results

2004-02-25 Thread Don Dikunetsis
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 "thi

fulltext search always returns no results

2004-02-25 Thread Don Dikunetsis
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