MySQL full text search equivalents to Google search: Difference between revisions

Jump to navigation Jump to search
mNo edit summary
Line 11: Line 11:
case2: Google search: {{kbd | key = keyword1 OR keyword2}}
case2: Google search: {{kbd | key = keyword1 OR keyword2}}
* Google: {{kbd | key = <nowiki>易筋經 OR 吸星大法</nowiki>}}
* Google: {{kbd | key = <nowiki>易筋經 OR 吸星大法</nowiki>}}
* MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' OR column_name REGEXP '吸星大法'</nowiki>}} ([http://ideone.com/YvxASY
* MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' OR column_name REGEXP '吸星大法'</nowiki>}}
online demo])
* 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>}}


== NOT ==
== NOT ==

Navigation menu