Reputation: 489

Full Text Search Like in InnoDB

How we can do Full Text Search in InnoDB?

Upvotes: 2

Answers (7)

Hieu Vo

Reputation: 3274

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

Upvotes: 0

Mehdi Karamosly

Reputation: 5428

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

Upvotes: 0

MPR

Reputation: 21

In mysql 5.6 Innodb full text search FTS facility provided.

Upvotes: 1

ovais.tariq

Reputation: 2625

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

Upvotes: 1

nos

Reputation: 229058

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.

Upvotes: 0

Frankie

Reputation: 25165

Fulltext seach is MyISAM only.

Upvotes: 0

BoltClock

Reputation: 723448

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

Upvotes: 6

Full Text Search Like in InnoDB

Answers (7)

Related Questions