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

From LemonWiki共筆
Jump to navigation Jump to search
No edit summary
mNo edit summary
Line 1: Line 1:




Google search:  {{kbd | key = keyword1 keyword2}} same as {{kbd | key = keyword1 AND keyword2}} or {{kbd | key = keyword1 +keyword2}}. {{exclaim}} The following is '''exact words''' search.
Google search:  {{kbd | key = keyword1 keyword2}} same as {{kbd | key = keyword1 AND keyword2}} or {{kbd | key = keyword1 +keyword2}}. {{exclaim}} (1) The following is '''exact words''' search. (2) Replace ''column_name'' with your column name
* MySQL: {{kbd | key = <nowiki>tags REGEXP '易筋經' AND tags 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>tags LIKE '%易筋經%' AND tags LIKE '%吸星大法%'</nowiki>}}
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name LIKE '%吸星大法%'</nowiki>}}
* MySQL: {{kbd | key = <nowiki>tags LIKE '%易筋經%吸星大法%' AND tags LIKE '%吸星大法%易筋經%'</nowiki>}} Trivial for multiple keywords
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%吸星大法%' AND column_name LIKE '%吸星大法%易筋經%'</nowiki>}} Trivial for multiple keywords


Google search: {{kbd | key = keyword1 OR keyword2}}
Google search: {{kbd | key = keyword1 OR keyword2}}
* MySQL: {{kbd | key = <nowiki>tags REGEXP '易筋經' OR tags REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/5/0 online demo])
* MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' OR column_name REGEXP '吸星大法'</nowiki>}} ([http://sqlfiddle.com/#!2/6fe6a6/5/0 online demo])
* MySQL: {{kbd | key = <nowiki>tags LIKE '%易筋經%' OR tags LIKE '%吸星大法%'</nowiki>}}
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' OR column_name LIKE '%吸星大法%'</nowiki>}}


Google search: {{kbd | key = keyword1 NOT keyword2}} same as {{kbd | key = keyword1 -keyword2}}
Google search: {{kbd | key = keyword1 NOT keyword2}} same as {{kbd | key = keyword1 -keyword2}}
* MySQL: {{kbd | key = <nowiki>tags REGEXP '易筋經' AND tags 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>tags LIKE '%易筋經%' AND tags NOT LIKE '%吸星大法%'</nowiki>}}
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name NOT LIKE '%吸星大法%'</nowiki>}}




Revision as of 13:44, 2 February 2015


Google search: keyword1 keyword2 same as keyword1 AND keyword2 or keyword1 +keyword2. Icon_exclaim.gif (1) The following is exact words search. (2) Replace column_name with your column name

  • MySQL: column_name REGEXP '易筋經' AND column_name REGEXP '吸星大法' (online demo)
  • MySQL: column_name LIKE '%易筋經%' AND column_name LIKE '%吸星大法%'
  • MySQL: column_name LIKE '%易筋經%吸星大法%' AND column_name LIKE '%吸星大法%易筋經%' Trivial for multiple keywords

Google search: keyword1 OR keyword2

  • MySQL: column_name REGEXP '易筋經' OR column_name REGEXP '吸星大法' (online demo)
  • MySQL: column_name LIKE '%易筋經%' OR column_name LIKE '%吸星大法%'

Google search: keyword1 NOT keyword2 same as keyword1 -keyword2

  • MySQL: column_name REGEXP '易筋經' AND column_name NOT REGEXP '吸星大法' (online demo)
  • MySQL: column_name LIKE '%易筋經%' AND column_name NOT LIKE '%吸星大法%'


related articles:

related news:

MySQL related news
Failed to load RSS feed from https://news.google.com.tw/news/feeds?pz=1&cf=all&ned=us&hl=en-US&q=mysql&cf=all&scoring=n&output=rss: Error parsing XML for RSS
Retrieved from "https://wiki.planetoid.info/index.php?title=MySQL_full_text_search_equivalents_to_Google_search&oldid=14539"