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 12:27, 4 March 2015
, 4 March 2015no edit summary
mNo edit summary |
mNo edit summary |
||
| Line 5: | Line 5: | ||
* 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]) | ||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name LIKE '%吸星大法%'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name LIKE '%吸星大法%'</nowiki>}} | ||
* 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>}} {{exclaim}} Trivial for multiple keywords | ||
case2: Google search: {{kbd | key = keyword1 OR keyword2}} | case2: Google search: {{kbd | key = keyword1 OR keyword2}} | ||