Bug #34566 Search for all (instead of any) words
Submitted: 14 Feb 2008 20:21 Modified: 1 May 2012 11:00
Reporter: Olaf van der Spek (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Websites: bugs.mysql.com Severity:S3 (Non-critical)
Version:* OS:Any (*)
Assigned to: Assigned Account CPU Architecture:Any
Tags: qc

[14 Feb 2008 20:21] Olaf van der Spek
Description:
Hi,

Would it be possible to add a search for all words instead of any words?
Any really doesn't work for me.

How to repeat:
Search for side by side.
[3 Nov 2008 5:18] Valeriy Kravchuk
Thank you for a reasonable feature request.
[28 Apr 2012 15:07] Vlad Safronov
Advanced search tab offers "Boolean search" http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html.

Basically start every word with +, e.g.: "+keyword1 +keyword2 +keyword3".

Would that work for you?
[28 Apr 2012 15:09] Olaf van der Spek
Hi Vlad,

It's a work around, it should really be the default.
[28 Apr 2012 17:32] Vlad Safronov
I see Google sets a high mark on sites search mechanics but it's a not a workaround. 
Would you post here your search examples?
[1 May 2012 11:00] Olaf van der Spek
If I search for fast cars, I'm not interested in *fast* planes or in slow *cars*, I want *fast* *cars*.
It just doesn't make sense to default to OR instead of AND.
[2 May 2012 12:28] Vlad Safronov
and what if we have only "sport" and "economy" cars? Return empty results page?

Search does not actually use "OR" or "AND" modes it has NATURAL LANGUAGE MODE (default) http://dev.mysql.com/doc/refman/5.5/en/fulltext-natural-language.html 
and BOOLEAN MODE http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html for advanced users.

Also one might use google: "search phrase site:bugs.mysql.com".
 
Given that I am going to set this "Won't fix".