MySQL full text search equivalents to Google search: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 36: | Line 36: | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||
[[Category:Google]] | [[Category:Google]] | ||
[[Category:Search]] | |||
[[Category:Data Science]] | [[Category:Data Science]] | ||
Revision as of 16:59, 2 February 2015
Google search: keyword1 keyword2 same as keyword1 AND keyword2 or keyword1 +keyword2. 
(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:
- MySQL :: MySQL 5.1 Reference Manual :: 12.5.2 Regular Expressions
- Google 進階搜尋
- Yahoo Advanced Web Search
- Advanced search options of bing
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
|