MySQL Forums
Forum List  »  Full-Text Search

Re: Converting from FULL-TEXT SEARCH to LIKE search
Posted by: Brian Moon
Date: December 07, 2005 08:03AM

You will not be able to use relevance any more.

Us this query if a user searches for: mysql fulltext

SELECT topic,user,time FROM posts WHERE body LIKE '%mysql%' and body LIKE %fulltext%' LIMIT 10;

You could ask your provider to leave that one table as MyISAM. That's a bummer that they just switched it on you.

Brian Moon
Phorum Dev Team
http://phorum.org/
-----------------------
dealnews.com - How to go broke saving money.
http://dealnews.com/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Converting from FULL-TEXT SEARCH to LIKE search
2306
December 07, 2005 08:03AM


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.