MySQL Forums
Forum List  »  Full-Text Search

Converting from FULL-TEXT SEARCH to LIKE search
Posted by: Joe Bloggs
Date: November 05, 2005 08:08AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Converting from FULL-TEXT SEARCH to LIKE search
3072
November 05, 2005 08:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.