Converting from FULL-TEXT SEARCH to LIKE search

[Joe Bloggs]

Hi everyone,

I have the following problem - I was running a forum that used FULLTEXT search to locate posts, but for some reason my webhost changed my db engine from MyISAM to InnoDB, which doesnt support FULLTEXT searches. My question is how to convert my queries to be compatible with InnoDB and give the same results as the FULLTEXT search.

I changed the original:
SELECT topic,user,time FROM posts WHERE MATCH (body) AGAINST (keywords) LIMIT...

to:
SELECT topic,user,time FROM posts WHERE body LIKE '%key%words%' LIMIT...

But it returns strange results :(


Thanks in advance for the help.