MySQL full text search equivalents to Google search: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
| Line 3: | Line 3: | ||
case1: Google search: {{kbd | key = keyword1 keyword2}} same as {{kbd | key = keyword1 AND keyword2}} or {{kbd | key = keyword1 +keyword2}}. {{exclaim}} (1) The following is '''exact words''' search. (2) Replace ''column_name'' with your column name | case1: Google search: {{kbd | key = keyword1 keyword2}} same as {{kbd | key = keyword1 AND keyword2}} or {{kbd | key = keyword1 +keyword2}}. {{exclaim}} (1) The following is '''exact words''' search. (2) Replace ''column_name'' with your column name | ||
* Google: {{kbd | key = <nowiki>易筋經 AND 吸星大法</nowiki>}} | * Google: {{kbd | key = <nowiki>易筋經 AND 吸星大法</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' AND column_name REGEXP '吸星大法'</nowiki>}} ([http:// | * MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' AND column_name REGEXP '吸星大法'</nowiki>}} ([ | ||
http://ideone.com/BCKFa9 online demo]) | |||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name LIKE '%吸星大法%'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' AND column_name LIKE '%吸星大法%'</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%吸星大法%' AND column_name LIKE '%吸星大法%易筋經%'</nowiki>}} {{exclaim}} Trivial for multiple keywords | * MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%吸星大法%' AND column_name LIKE '%吸星大法%易筋經%'</nowiki>}} {{exclaim}} Trivial for multiple keywords | ||
| Line 10: | Line 11: | ||
case2: Google search: {{kbd | key = keyword1 OR keyword2}} | case2: Google search: {{kbd | key = keyword1 OR keyword2}} | ||
* Google: {{kbd | key = <nowiki>易筋經 OR 吸星大法</nowiki>}} | * Google: {{kbd | key = <nowiki>易筋經 OR 吸星大法</nowiki>}} | ||
* MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' OR column_name REGEXP '吸星大法'</nowiki>}} ([http:// | * MySQL: {{kbd | key = <nowiki>column_name REGEXP '易筋經' OR column_name REGEXP '吸星大法'</nowiki>}} ([http://ideone.com/YvxASY | ||
online demo]) | |||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' OR column_name LIKE '%吸星大法%'</nowiki>}} | * MySQL: {{kbd | key = <nowiki>column_name LIKE '%易筋經%' OR column_name LIKE '%吸星大法%'</nowiki>}} | ||
Revision as of 10:25, 9 March 2015
AND
case1: 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
- Google: 易筋經 AND 吸星大法
- MySQL: column_name REGEXP '易筋經' AND column_name REGEXP '吸星大法' ([
http://ideone.com/BCKFa9 online demo])
- MySQL: column_name LIKE '%易筋經%' AND column_name LIKE '%吸星大法%'
- MySQL: column_name LIKE '%易筋經%吸星大法%' AND column_name LIKE '%吸星大法%易筋經%' Trivial for multiple keywords
OR
case2: Google search: keyword1 OR keyword2
- Google: 易筋經 OR 吸星大法
- MySQL: column_name REGEXP '易筋經' OR column_name REGEXP '吸星大法' ([http://ideone.com/YvxASY
online demo])
- MySQL: column_name LIKE '%易筋經%' OR column_name LIKE '%吸星大法%'
NOT
case3: Google search: keyword1 NOT keyword2 same as keyword1 -keyword2
- Google: 易筋經 NOT 吸星大法
- MySQL: column_name REGEXP '易筋經' AND column_name NOT REGEXP '吸星大法' (online demo)
- MySQL: column_name LIKE '%易筋經%' AND column_name NOT LIKE '%吸星大法%'
* wildcard operator
case4: Google * wildcard operator. "Use *, an asterisk character, known as a wildcard, to match one or more words in a phrase" [1] (online demo)
- Google: 狐狸*叫
- MySQL: column_name LIKE '狐狸%叫'[2]
to explore strange new worlds / related articles:
- MySQL :: MySQL 5.1 Reference Manual :: 12.5.2 Regular Expressions
- Google 進階搜尋, Punctuation, symbols & operators in search - Search Help
- Yahoo Advanced Web Search
- Advanced search options of bing
references
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
|