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 14:59, 9 March 2015
, 9 March 2015→OR
m (→AND) |
m (→OR) |
||
| Line 11: | Line 11: | ||
* Google: {{kbd | key = <nowiki>易筋經 OR 吸星大法</nowiki>}} | * Google: {{kbd | key = <nowiki>易筋經 OR 吸星大法</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' OR column_name REGEXP '吸星大法'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' OR column_name REGEXP '吸星大法'</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' OR column_name LIKE '%吸星大法%'</nowiki>}} ([http://ideone.com/YvxASY online demo]) | * MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' OR column_name LIKE '%吸星大法%'</nowiki>}} ([http://ideone.com/YvxASY online demo][http://sqlfiddle.com/#!9/6ec57/2/0]) | ||
== NOT == | == NOT == | ||