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 02:16, 30 January 2015
, 30 January 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}}. {{exclaim}} The following is '''exact words''' search. | Google search: {{kbd | key = keyword1 keyword2}} same as {{kbd | key = keyword1 AND keyword2}} or {{kbd | key = keyword1 +keyword2}}. {{exclaim}} The following is '''exact words''' search. | ||
* MySQL: {{kbd | key = <nowiki>tags REGEXP '易筋經' AND tags REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/7/0 online demo]) | * 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>}} | ||