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 17:23, 15 April 2016
, 15 April 2016→NOT
m (→OR) |
m (→NOT) |
||
| Line 19: | Line 19: | ||
* 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>IF(LOCATE('易筋經', column_name) > 0) AND IF(LOCATE('吸星大法, column_name) = 0)</nowiki>}} | |||
* 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>}} | ||