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 14:58, 7 January 2017
, 7 January 2017→* wildcard operator
| Line 26: | Line 26: | ||
* Google: {{kbd | key = <nowiki>狐狸*叫</nowiki>}} | * Google: {{kbd | key = <nowiki>狐狸*叫</nowiki>}} | ||
* 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> | ||
== Ignore special characters == | |||
Ignore return symbol | |||
* Searched the keywords e.g. {{kbd | key = <nowiki>"意法" site:ptt.cc</nowiki>}} on Google and found the search result contains 意 & 法 located in the nearest but different rows. 意 is at the end of the n-th row. 法 is at the beginning of n+1-th row [https://www.ptt.cc/man/Learn_Buddha/D7D5/D575/DFD/D15C/M.1317265764.A.B7D.html]. | |||
Ignore space, [https://en.wikipedia.org/wiki/Halfwidth_and_fullwidth_forms Halfwidth and fullwidth symbol] (半形字元和全形字元) | |||
* Searched the keywords e.g. {{kbd | key = <nowiki>"嗎有"</nowiki>}} on Google and found the search result contains {{kbd | key = <nowiki>嗎？ 有</nowiki>}} & {{kbd | key = <nowiki>嗎- 有</nowiki>}}. | |||
== references or related articles == | == references or related articles == | ||