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

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




related articles:
to explore strange new worlds / related articles:
* [http://dev.mysql.com/doc/refman/5.1/en/regexp.html MySQL :: MySQL 5.1 Reference Manual :: 12.5.2 Regular Expressions]
* [http://dev.mysql.com/doc/refman/5.1/en/regexp.html MySQL :: MySQL 5.1 Reference Manual :: 12.5.2 Regular Expressions]
* [https://www.google.com/advanced_search Google 進階搜尋]
* [https://www.google.com/advanced_search Google 進階搜尋], [https://support.google.com/websearch/answer/2466433?hl=en&rd=1 Punctuation, symbols & operators in search - Search Help]
* [https://search.yahoo.com/search/options?fr=fp-top&p= Yahoo Advanced Web Search]
* [https://search.yahoo.com/search/options?fr=fp-top&p= Yahoo Advanced Web Search]
* [http://onlinehelp.microsoft.com/en-us/bing/ff808438.aspx Advanced search options] of bing
* [http://onlinehelp.microsoft.com/en-us/bing/ff808438.aspx Advanced search options] of bing

Revision as of 16:28, 15 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 '%吸星大法%'


to explore strange new worlds / 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=14586"