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 進階搜尋