15,032
edits
MySQL full text search equivalents to Google search: Difference between revisions
Jump to navigation
Jump to search
m
MySQL full text search equivalents to Google search (edit)
Revision as of 16:43, 19 February 2015
, 19 February 2015no edit summary
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
Google search: {{kbd | key = keyword1 keyword2}} same as {{kbd | key = keyword1 AND keyword2}} or {{kbd | key = keyword1 +keyword2}}. {{exclaim}} (1) The following is '''exact words''' search. (2) Replace ''column_name'' with your column name | case1: Google search: {{kbd | key = keyword1 keyword2}} same as {{kbd | key = keyword1 AND keyword2}} or {{kbd | key = keyword1 +keyword2}}. {{exclaim}} (1) The following is '''exact words''' search. (2) Replace ''column_name'' with your column name | ||
* Google: {{kbd | key = <nowiki>易筋經 AND 吸星大法</nowiki>}} | * Google: {{kbd | key = <nowiki>易筋經 AND 吸星大法</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' AND column_name REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/7/0 online demo]) | * MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' AND column_name REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/7/0 online demo]) | ||
| Line 7: | Line 7: | ||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%吸星大法%' AND column_name LIKE '%吸星大法%易筋經%'</nowiki>}} Trivial for multiple keywords | * MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%吸星大法%' AND column_name LIKE '%吸星大法%易筋經%'</nowiki>}} Trivial for multiple keywords | ||
Google search: {{kbd | key = keyword1 OR keyword2}} | case2: Google search: {{kbd | key = keyword1 OR keyword2}} | ||
* Google: {{kbd | key = <nowiki>易筋經 OR 吸星大法</nowiki>}} | * Google: {{kbd | key = <nowiki>易筋經 OR 吸星大法</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' OR column_name REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/5/0 online demo]) | * MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' OR column_name REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/5/0 online demo]) | ||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' OR column_name LIKE '%吸星大法%'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' OR column_name LIKE '%吸星大法%'</nowiki>}} | ||
Google search: {{kbd | key = keyword1 NOT keyword2}} same as {{kbd | key = keyword1 -keyword2}} | case3: Google search: {{kbd | key = keyword1 NOT keyword2}} same as {{kbd | key = keyword1 -keyword2}} | ||
* Google: {{kbd | key = <nowiki>易筋經 NOT 吸星大法</nowiki>}} | * Google: {{kbd | key = <nowiki>易筋經 NOT 吸星大法</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' AND column_name NOT REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/9/0 online demo]) | * MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' AND column_name NOT REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/9/0 online demo]) | ||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name NOT LIKE '%吸星大法%'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name NOT LIKE '%吸星大法%'</nowiki>}} | ||
Google * wildcard operator. "Use *, an asterisk character, known as a wildcard, to match one or more words in a phrase" <ref>[http://www.googleguide.com/wildcard_operator.html Google's * Wildcard Operator - Google Guide]</ref> ([http://sqlfiddle.com/#!2/e148e/1/0 online demo]) | case4: Google * wildcard operator. "Use *, an asterisk character, known as a wildcard, to match one or more words in a phrase" <ref>[http://www.googleguide.com/wildcard_operator.html Google's * Wildcard Operator - Google Guide]</ref> ([http://sqlfiddle.com/#!2/e148e/1/0 online demo]) | ||
* Google: {{kbd | key = <nowiki>狐狸*叫</nowiki>}} | * Google: {{kbd | key = <nowiki>狐狸*叫</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '狐狸%叫'</nowiki>}}<ref>[http://www.mysqltutorial.org/mysql-like/ Using MySQL LIKE Operator to Select Data Based on Pattern Matching]</ref> | * MySQL: {{kbd | key = <nowiki>column_name LIKE '狐狸%叫'</nowiki>}}<ref>[http://www.mysqltutorial.org/mysql-like/ Using MySQL LIKE Operator to Select Data Based on Pattern Matching]</ref> | ||