MySQL full text search equivalents to Google search: Difference between revisions

Jump to navigation Jump to search
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 ==

Navigation menu