List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:May 26 2003 3:08pm
Subject:Re: Defaulting fulltext search to 'AND'?
View as plain text  
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:
	http://www.mysql.com/doc/en/Fulltext_Search.html


-- 
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
       <___/   www.mysql.com




Thread
Minimum Requirement to run a MySQL test setupNitin Nanivadekar23 May
  • Re: Minimum Requirement to run a MySQL test setupDan Nelson23 May
  • MySQL using filesort :(Jason Hamilton23 May
    • re: MySQL using filesort :(Egor Egorov23 May
      • re: MySQL using filesort :(Jason Hamilton23 May
        • re: MySQL using filesort :(Jason Hamilton23 May
        • re: MySQL using filesort :(Egor Egorov23 May
          • re: MySQL using filesort :(Jason Hamilton23 May
            • Re: re: MySQL using filesort :(Egor Egorov24 May
              • Defaulting fulltext search to 'AND'?Jason Hamilton24 May
                • Re: Defaulting fulltext search to 'AND'?Victoria Reznichenko26 May
              • Re: re: MySQL using filesort :(Egor Egorov26 May
RE: Minimum Requirement to run a MySQL test setupMike Hillyer23 May