MySQL full text search equivalents to Google search

From LemonWiki共筆

Revision as of 12:21, 27 January 2015 by Planetoid (talk | contribs) (Created page with " Google search: {{kbd | key = keyword1 keyword2}} same as {{kbd | key = keyword1 AND keyword2}} ([http://sqlfiddle.com/#!2/6fe6a6/7/0 online demo]). {{exclaim}} The followin...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

Google search: keyword1 keyword2 same as keyword1 AND keyword2 (online demo). The following is exact words search.

MySQL: tags REGEXP '易筋經' AND tags REGEXP '吸星大法'
MySQL: tags LIKE '%易筋經%' AND tags LIKE '%吸星大法%'
MySQL: tags LIKE '%易筋經%吸星大法%' AND tags LIKE '%吸星大法%易筋經%' Trivial for multiple keywords

Google search: keyword1 OR keyword2 (online demo)

MySQL: tags REGEXP '易筋經' OR tags REGEXP '吸星大法'
MySQL: tags LIKE '%易筋經%' OR tags LIKE '%吸星大法%'

Google search: keyword1 NOT keyword2 same as keyword1 -keyword2 (online demo)

MySQL: tags REGEXP '易筋經' AND tags NOT REGEXP '吸星大法'
MySQL: tags LIKE '%易筋經%' AND tags NOT LIKE '%吸星大法%'

related articles:

Retrieved from "https://wiki.planetoid.info/index.php?title=MySQL_full_text_search_equivalents_to_Google_search&oldid=14513"