MySQL full text search equivalents to Google search: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 18: | Line 18: | ||
* [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] | ||
* [http://www.google.im/advanced_search Google 進階搜尋] | * [http://www.google.im/advanced_search Google 進階搜尋] | ||
相關新聞: | |||
<div style="width: 90%;"> | |||
{| | |||
! class="nounderlinelink" style="background-color: #EEEEEE; text-align: center; padding: 0px" | <span style="padding-left: 7px">MySQL 相關新聞聯播</span> | |||
|- | |||
| 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> | |||
[[Category:Programming]] | [[Category:Programming]] | ||
Revision as of 16:01, 28 January 2015
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 相關新聞聯播 |
|---|
|
Failed to load RSS feed from https://news.google.com.tw/news/feeds?pz=1&cf=all&ned=tw&hl=zh-TW&q=mysql&cf=all&scoring=n&output=rss: Error parsing XML for RSS
|