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

From LemonWiki共筆
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 26: Line 26:
|-
|-
| style="font-size: 1em;" |
| style="font-size: 1em;" |
<div style="margin-left: 10px;"><rss>https://news.google.com.tw/news/feeds?pz=1&cf=all&ned=tw&hl=zh-TW&q=mysql&cf=all&scoring=n&output=rss</rss></div>
<div style="margin-left: 10px;"><rss>https://news.google.com.tw/news/feeds?pz=1&cf=all&ned=tw&hl=en-US&q=mysql&cf=all&scoring=n&output=rss</rss></div>
|}</div>
|}</div>


Revision as of 16:03, 28 January 2015


Google search: keyword1 keyword2 same as keyword1 AND keyword2. Icon_exclaim.gif 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 相關新聞聯播
Failed to load RSS feed from https://news.google.com.tw/news/feeds?pz=1&cf=all&ned=tw&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=14516"