Skip navigation links

MySQL Forums :: Full-Text Search :: Problem/Solution: using negative phrases in FULLTEXT BOOLEAN MODE


Advanced 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: Reply•Quote


Subject Views Written By Posted
Problem/Solution: using negative phrases in FULLTEXT BOOLEAN MODE 2408 Harry Hege 02/23/2011 10:19AM
Re: Problem/Solution: using negative phrases in FULLTEXT BOOLEAN MODE 1068 Harry Hege 02/24/2011 03:08PM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

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.