How to do full text search in innodb table??

[marcellusc]

Problem: how to do full text search in innodb table?

MySQL has feature of full text search... that's great.

http://www.mysql.com/doc/en/Fulltext_Search.html

But the problem is it only works in MyISAM table. What about for innoDB? is there a workaround to this?

I mean, surely most people use innodb for large-scale databases?

Or it simply doesn't work at innodb table at all? Hence we have no choice but to use 'like %keyword%'?

any inputs will be appreciated...

[toasti]

you might find that using 'like %keyword% would actually work better than using the MySQL full-text search, cause it is actually quite limited (for starters, it only searches for words longer 3 letters (and you would be amazed how many good keywords are actually less than three letters))

as far as i know you can't use it in INNODB.

[toasti]

my bad:

The minimum length of words to be indexed is defined by the MySQL variable ft_min_word_len. See section 4.5.7.4 SHOW VARIABLES. Change it to the value you prefer, and rebuild your FULLTEXT indexes. (This variable is only available from MySQL version 4.0.)

(form the MySQL manual)