MySQL Forums
Forum List  »  Full-Text Search

Multiple words with boolean - still matching single word?
Posted by: Ben Sebborn
Date: December 03, 2007 06:00AM


We're using a boolean search in the form of:

WHERE ((MATCH (EventName, EventDesc) AGAINST ('+Keyword1 +Keyword2' IN BOOLEAN MODE) OR MATCH (Ent.Name, Ent.Town) AGAINST ('+Keyword1 +Keyword2' IN BOOLEAN MODE)))

However, we've noticed that this search is still returning matches which just contain Keyword1.

This is causing particular problems with a search on 'good times' - as a phrase it would be fine, but this is pulling back results with just the word 'good' in! I don't want to add good as a stop word as it is relevent, but I really need to search for the keywords as a phrase! Any ideas?

Options: ReplyQuote

Written By
Multiple words with boolean - still matching single word?
December 03, 2007 06:00AM

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.