MySQL Forums
Forum List  »  Full-Text Search

Re: Problem/Solution: using negative phrases in FULLTEXT BOOLEAN MODE
Posted by: Harry Hege
Date: February 24, 2011 03:08PM

This problem is more widespread than you might think.

On my system, I ran several FULLTEXT BOOLEAN MODE searches with the following results:
'+aeronautics +company' (41)
'"aeronautics company"' (3)
'+aeronautics +company -"aeronautics company"' (0)

Try a search like the following on your system, but sit down first:
'+space +shuttle -"space shuttle"'
'+united +states -"united states"'

I find this more than a little disturbing.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problem/Solution: using negative phrases in FULLTEXT BOOLEAN MODE
1663
February 24, 2011 03:08PM


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.