15,032
edits
MySQL full text search equivalents to Google search: Difference between revisions
Jump to navigation
Jump to search
MySQL full text search equivalents to Google search (edit)
Revision as of 10:27, 9 March 2015
, 9 March 2015→AND
(→OR) |
(→AND) |
||
| Line 3: | Line 3: | ||
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 | 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>}} | * MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' AND column_name REGEXP '吸星大法'</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name LIKE '%吸星大法%'</nowiki>}} ([http://ideone.com/BCKFa9 online demo]) | |||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name LIKE '%吸星大法%'</nowiki>}} | |||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%吸星大法%' AND column_name LIKE '%吸星大法%易筋經%'</nowiki>}} {{exclaim}} Trivial for multiple keywords | * MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%吸星大法%' AND column_name LIKE '%吸星大法%易筋經%'</nowiki>}} {{exclaim}} Trivial for multiple keywords | ||