MySQL Forums
Forum List  »  MyISAM

Re: fulltext boolean search not returning a particular row
Posted by: Rick James
Date: September 02, 2012 06:01PM

If you also have a regular index on the title, a simple WHERE would fine it very fast.

Looking for a substring via
WHERE title LIKE '%think of me%'
would be slow, but perhaps not too slow, since you have only 2700 rows.

Explain your problem to the hosting service; see if they would help you out.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: fulltext boolean search not returning a particular row
1454
September 02, 2012 06:01PM


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.