FULLTEXT search

[Shaolin]

Hi Guys

I am working on a InnoDB database which handles alot of transactions. Now, I need to implement fulltext search but that only works on myisam. The only solution I have come across is to configure a seperate table for myisam and duplicate the search data. My questions:

1. Is this the only way ? Are there any other ways I can search multiple fields in an InnoDB ?

2. If I am to make another table just for search, how will I implement it ? Will I need to execute two queries ? One to insert data into the main table and another to insert it into the search table ? What if I rollback a transaction ?

[chazzy]

fulltext search does not require myisam. only the key. http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

you don't need to use the key to do the search.

[Shaolin]

But everytime I try to add fulltext search to my table without including myisam it tells me its not possible ? :confused: