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