Implementing database search through query using like
I am planning to implement database search through a website - I know there is full-text search offered by mysql, but turns out that it is not supported for innodb engine (which I need for transaction support). 
Other options are using sphinx or similar indexing applications. However they require some re factoring of the database structure and may take more time to implement than I have. 

So what I decided on was to take each table and concatenate all its relevant columns into a newly added QUERY column. This query column should also recruit from column of other relevant tables. 

This accomplished, I will  use the 'like' clause on query column of the table to be searched to search to return results of specific domains (group of related tables).

Since my database is not expected to be too huge (< 1mn rows in the biggest table), I am expecting reasonable query times. 

Does any one agree with this method or have a better idea?
Implementing database search through query using like
===

I am planning to implement database search through a website - I know there is full-text search offered by mysql, but turns out that it is not supported for innodb engine (which I need for transaction support). 
Other options are using sphinx or similar indexing applications. However they require some re factoring of the database structure and may take more time to implement than I have. 

So what I decided on was to take each table and concatenate all its relevant columns into a newly added QUERY column. This query column should also recruit from column of other relevant tables. 

This accomplished, I will  use the 'like' clause on query column of the table to be searched to search to return results of specific domains (group of related tables).

Since my database is not expected to be too huge (< 1mn rows in the biggest table), I am expecting reasonable query times. 

Does any one agree with this method or have a better idea?