Full Text Search Like in InnoDB

views:

answers:

+1 Q:

Full Text Search Like in InnoDB

Hey Friends
How we can do Full Text Search in InnoDB?

+3 A:

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

BoltClock 2010-08-17 17:59:18

@BoltClock +1 for Sphinx (daily vote run out though)

Frankie 2010-08-17 18:03:07

@Frankie: I know how running out of votes feels :/

BoltClock 2010-08-17 18:05:57

@BoltClock ah! But then one waits and comes back the day after! ;)

Frankie 2010-08-18 16:19:15

@Frankie: thank you!

BoltClock 2010-08-18 16:25:01

Fulltext seach is MyISAM only.

Frankie 2010-08-17 18:00:38

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.

nos 2010-08-17 18:01:38

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

ovais.tariq 2010-08-17 18:56:11

ansaurus

tags:

views:

answers:

Full Text Search Like in InnoDB

related questions