Search code examples
mysqlinnodbmyisamindexingfull-text-search

Switching MySQL table from MyISAM to InnoDB - What do I do with the Column Indexes that were FULLTEXT


I am switching some MySQL tables from MyISAM to InnoDB:

What should I use in place of FULLTEXT?

As InnoDB does not have FULLTEXT. What should I use in FULLTEXT's place, when switching from MyISAM to InnoDB?

Thanks all : )

Regards.


Solution

  • Starting with MySQL 5.6.4 fulltext indexes are supported for InnoDB. http://dev.mysql.com/doc/refman/5.6/en/fulltext-restrictions.html