MySQL Forums
Forum List  »  Full-Text Search

Re: Multiple words with boolean - still matching single word?
Posted by: Brad Garrett
Date: February 07, 2008 03:23PM

This is a major problem for me right now as well. It seems like an extremely basic scenario but doesn't seem to work. I want to return results that MUST have both terms somewhere in them, but mysql returns all rows featuring the first term.
My syntax looks like

SELECT * FROM thetable WHERE MATCH (title,keywords,description,content) AGAINST ('+crazy +believe' IN BOOLEAN MODE);

The results are all the rows with the word "crazy" even though only one of them also has the word "believe". Any ideas what is the issue?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Multiple words with boolean - still matching single word?
3749
February 07, 2008 03:23PM


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.