I don't think there is anything you can do that won't require a full
table scan. I think some people break out the field they want to do a
full text search on into another table using the MyISAM format. So your
"core" table is InnoDB and your full text search fields are in a
related table that
What is the best way to simulate a fulltext search on a MySQL table of type InnoDB?
Do I index the searchable fields and use the LIKE() function with appropriate
wildcards?
What are the performance implications with this? Switching back to a table type of
MyISAM is really not an option. Is t