Hi all,
In order to have reasonable performance in our LIKE '%abc%' queries that has a big lenght I need to use something more powerful than simple indexing provided in all DBMSs.
Oracle with Oracle Text and SQL Server with "MS indexing service" help me but I fear that there is no possible solution for MySQL. Also note that all my tables are InnoDB type tables for transaction support purpose.

Plz clarify me if I am wrong and there is a solution that combines Full text search with InnoDB tables.

Also I have read mysql documentation about this and could not find any workaround yet

-Thanks in advance