MySQL full text search equivalents to Google search: Difference between revisions
Jump to navigation
Jump to search
(Created page with " Google search: {{kbd | key = keyword1 keyword2}} same as {{kbd | key = keyword1 AND keyword2}} ([http://sqlfiddle.com/#!2/6fe6a6/7/0 online demo]). {{exclaim}} The followin...") |
mNo edit summary |
||
| Line 1: | Line 1: | ||
Google search: {{kbd | key = keyword1 keyword2}} same as {{kbd | key = keyword1 AND keyword2}} | Google search: {{kbd | key = keyword1 keyword2}} same as {{kbd | key = keyword1 AND keyword2}}. {{exclaim}} The following is '''exact words''' search. | ||
* MySQL: {{kbd | key = <nowiki>tags REGEXP '易筋經' AND tags REGEXP '吸星大法'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>tags REGEXP '易筋經' AND tags REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/7/0 online demo]) | ||
* MySQL: {{kbd | key = <nowiki>tags LIKE '%易筋經%' AND tags LIKE '%吸星大法%'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>tags LIKE '%易筋經%' AND tags LIKE '%吸星大法%'</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>tags LIKE '%易筋經%吸星大法%' AND tags LIKE '%吸星大法%易筋經%'</nowiki>}} Trivial for multiple keywords | * MySQL: {{kbd | key = <nowiki>tags LIKE '%易筋經%吸星大法%' AND tags LIKE '%吸星大法%易筋經%'</nowiki>}} Trivial for multiple keywords | ||
Google search: {{kbd | key = keyword1 OR keyword2}} | Google search: {{kbd | key = keyword1 OR keyword2}} | ||
* MySQL: {{kbd | key = <nowiki>tags REGEXP '易筋經' OR tags REGEXP '吸星大法'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>tags REGEXP '易筋經' OR tags REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/5/0 online demo]) | ||
* MySQL: {{kbd | key = <nowiki>tags LIKE '%易筋經%' OR tags LIKE '%吸星大法%'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>tags LIKE '%易筋經%' OR tags LIKE '%吸星大法%'</nowiki>}} | ||
Google search: {{kbd | key = keyword1 NOT keyword2}} same as {{kbd | key = keyword1 -keyword2}} | Google search: {{kbd | key = keyword1 NOT keyword2}} same as {{kbd | key = keyword1 -keyword2}} | ||
* MySQL: {{kbd | key = <nowiki>tags REGEXP '易筋經' AND tags NOT REGEXP '吸星大法'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>tags REGEXP '易筋經' AND tags NOT REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/9/0 online demo]) | ||
* MySQL: {{kbd | key = <nowiki>tags LIKE '%易筋經%' AND tags NOT LIKE '%吸星大法%'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>tags LIKE '%易筋經%' AND tags NOT LIKE '%吸星大法%'</nowiki>}} | ||
Revision as of 12:28, 27 January 2015
Google search: keyword1 keyword2 same as keyword1 AND keyword2. 
The following is exact words search.
- MySQL: tags REGEXP '易筋經' AND tags REGEXP '吸星大法' (online demo)
- MySQL: tags LIKE '%易筋經%' AND tags LIKE '%吸星大法%'
- MySQL: tags LIKE '%易筋經%吸星大法%' AND tags LIKE '%吸星大法%易筋經%' Trivial for multiple keywords
Google search: keyword1 OR keyword2
- MySQL: tags REGEXP '易筋經' OR tags REGEXP '吸星大法' (online demo)
- MySQL: tags LIKE '%易筋經%' OR tags LIKE '%吸星大法%'
Google search: keyword1 NOT keyword2 same as keyword1 -keyword2
- MySQL: tags REGEXP '易筋經' AND tags NOT REGEXP '吸星大法' (online demo)
- MySQL: tags LIKE '%易筋經%' AND tags NOT LIKE '%吸星大法%'
related articles: