Full Text Search Like in InnoDB

How we can do Full Text Search in 开发者_StackOverflowInnoDB?

InnoDB doesn't natively support full-text search. You can use Sphinx to accomplish something similar to this though, I believe.

Innodb doesnt support full text searching, if you really need full text searching then what you can do is have a duplicate mysiam table of the original innodb table and have your full text search done on the duplicate table

In mysql 5.6 Innodb full text search FTS facility provided.

Fulltext seach is MyISAM only.

You don't. InnoDB does not support fulltext indexes.

Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns. From here.

Just an update to this thread, MySql 5.6 now supports FULLTEXT indexes in innoDb : http://dev.mysql.com/doc/refman/5.6/en/innodb-table-and-index.html#innodb-fulltext-index

The answer for this question is outdated, InnoDB supported fulltext search already in MySQL 5.6, check here for more information