MySQL Forums
Forum List  »  InnoDB

How to make exact full text search in an INNODB table.
Posted by: Naveen Kumar
Date: February 28, 2005 12:57AM

My table is innodb format, when I execute the query the given below error occurs.

Can't do query : select email_add, sub_id from m_subscribe_h where match(email_add) against ('p.naveen@phoenixlogin.com') and status = '1' and unsubscribe = '0'
1191: Can't find FULLTEXT index matching the column list

so please send the query syntax of exact full text search in a innodb table. OR
exact search of email address with innodb table field.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to make exact full text search in an INNODB table.
3526
February 28, 2005 12:57AM


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.