MySQL Forums
Forum List  »  InnoDB

Re: InnoDB and FULLTEXT
Posted by: Naveen Kumar
Date: February 28, 2005 12:54AM

How to make exact full text search in an INNODB table.

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

so please send the query syntax of exact full text search in a innodb table.

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

Options: ReplyQuote


Subject
Views
Written By
Posted
14470
January 24, 2005 07:13AM
8550
January 24, 2005 01:10PM
6782
January 25, 2005 01:37AM
6082
January 26, 2005 07:50AM
5642
January 28, 2005 04:34AM
10040
January 28, 2005 04:45PM
5460
February 01, 2005 07:04AM
Re: InnoDB and FULLTEXT
6281
February 28, 2005 12:54AM


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.