15,032
edits
MySQL full text search equivalents to Google search: Difference between revisions
Jump to navigation
Jump to search
MySQL full text search equivalents to Google search (edit)
Revision as of 15:14, 13 March 2015
, 13 March 2015→* wildcard operator
m (→OR) |
|||
| Line 24: | Line 24: | ||
* MySQL: {{kbd | key = <nowiki>column_name LIKE '狐狸%叫'</nowiki>}}<ref>[http://www.mysqltutorial.org/mysql-like/ Using MySQL LIKE Operator to Select Data Based on Pattern Matching]</ref> | * MySQL: {{kbd | key = <nowiki>column_name LIKE '狐狸%叫'</nowiki>}}<ref>[http://www.mysqltutorial.org/mysql-like/ Using MySQL LIKE Operator to Select Data Based on Pattern Matching]</ref> | ||
== references or related articles == | |||
to explore strange new worlds / 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] | ||
| Line 29: | Line 30: | ||
* [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 | ||
other search cases: if the column ... (inspired by [http://www.outwit.com/ OutWit]) | |||
* contains ____ | |||
* does not contain ____ | |||
* begins with ____ | |||
* does not begins with ____ | |||
* ends with ____ | |||
* does not ends with ____ | |||
* equals to ____ | |||
* does not equal ____ | |||
references | references | ||