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 10:40, 13 February 2017
, 13 February 2017no edit summary
No edit summary |
|||
| Line 35: | Line 35: | ||
* Searched the keywords e.g. {{kbd | key = <nowiki>"人物誌Persona"</nowiki>}} on Google and found the search result contains {{kbd | key = <nowiki>人物誌（Persona）</nowiki>}}, {{kbd | key = <nowiki>人物誌(Persona) </nowiki>}} & {{kbd | key =<nowiki>「人物誌」（persona）</nowiki>}}. | * Searched the keywords e.g. {{kbd | key = <nowiki>"人物誌Persona"</nowiki>}} on Google and found the search result contains {{kbd | key = <nowiki>人物誌（Persona）</nowiki>}}, {{kbd | key = <nowiki>人物誌(Persona) </nowiki>}} & {{kbd | key =<nowiki>「人物誌」（persona）</nowiki>}}. | ||
== | == Ranking factors == | ||
Possibile factors | |||
* Google [https://en.wikipedia.org/wiki/PageRank PageRank - Wikipedia] | |||
* [http://www.w3resource.com/mysql/string-functions/mysql-position-function.php MySQL POSITION() function - w3resource] / [http://www.w3resource.com/mysql/string-functions/mysql-length-function.php MySQL LENGTH() function - w3resource] where the keywords located. | |||
== 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] | ||