Jason Hamilton <jason@stripped> wrote:
> By default, fulltext searches in bool mode uses 'OR'.
> Doing a search for 'rental car' results with matches
> to both words with higher relevancy than matches with
> only one of the two.
> Is there a way to default MySQL to 'AND'? So that a search
> for 'rental car' results in only matches containing
> both words? I realize that I could process the user's input
> string, breaking up the input and prefixing each word with
> a '+', but I would rather avoid this if at all possible.
Yes, you can use '+' to retrieve rows containing both words. If you want to find exactly
search phrase, take a look at phrase search:
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net