Unanswered: Full text search + transaction support in mysql?
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.