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 19:28, 28 August 2017
, 28 August 2017→Ignore special characters
| Line 38: | Line 38: | ||
** 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>}}. | ||
* Approach: (1) remove the space symbol (2) remove the Halfwidth and fullwidth symbol. | * Approach: (1) remove the space symbol (2) remove the Halfwidth and fullwidth symbol. | ||
* References: [https://stackoverflow.com/questions/16733674/php-remove-symbols-from-string PHP remove symbols from string - Stack Overflow] | |||
== Highlight search query keywords on resulting pages == | == Highlight search query keywords on resulting pages == | ||