MySQL full text search equivalents to Google search

Google search: keyword1 keyword2 same as keyword1 AND keyword2. The following is exact words search.

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

Google search: keyword1 OR keyword2

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

Google search: keyword1 NOT keyword2 same as keyword1 -keyword2

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

related articles:

• MySQL :: MySQL 5.1 Reference Manual :: 12.5.2 Regular Expressions
• Google 進階搜尋

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