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/
Subject
Views
Written By
Posted
3313
November 05, 2005 08:08AM
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.