MySQL Forums
Forum List  »  Full-Text Search

FULLTEXT and MySQL 4.0
Posted by: Joel Hughes
Date: March 19, 2007 05:16AM

Hi,
I'm having a minor issuette with full text searching in MYSQL (version 4.0.23).

I have added fulltext index onto the columns I want


FULLTEXT KEY `search` (`articles_titletext`,`articles_text`),


However, when I run a query such as

select * from articles where match(articles_text) against ('{search term}');

I get...

Can't find FULLTEXT index matching the column list


Now, the index is there fine, I can see it when I describe the table.

Any ideas where the problem lies?

thanks

Joel Hughes

Options: ReplyQuote


Subject
Views
Written By
Posted
FULLTEXT and MySQL 4.0
3284
March 19, 2007 05:16AM
2303
May 01, 2007 09:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.