List:General Discussion« Previous MessageNext Message »
From:Jason Hamilton Date:May 24 2003 2:56pm
Subject:Defaulting fulltext search to 'AND'?
View as plain text  
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.

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