15,032
edits
MySQL full text search equivalents to Google search: Difference between revisions
Jump to navigation
Jump to search
MySQL full text search equivalents to Google search (edit)
Revision as of 17:21, 15 April 2016
, 15 April 2016→AND
(→AND) |
|||
| Line 5: | Line 5: | ||
* MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' AND column_name REGEXP '吸星大法'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' AND column_name REGEXP '吸星大法'</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name LIKE '%吸星大法%'</nowiki>}} ([http://ideone.com/BCKFa9 online demo][http://sqlfiddle.com/#!9/6ec57/1/0]) | * MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name LIKE '%吸星大法%'</nowiki>}} ([http://ideone.com/BCKFa9 online demo][http://sqlfiddle.com/#!9/6ec57/1/0]) | ||
* 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 LIKE '%吸星大法%易筋經%'</nowiki>}} {{exclaim}} Trivial for multiple keywords | * MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%吸星大法%' AND column_name LIKE '%吸星大法%易筋經%'</nowiki>}} {{exclaim}} Trivial for multiple keywords | ||