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.
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.
Subject
Views
Written By
Posted
How to make exact full text search in an INNODB table.
3741
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.