Syntax\n------\n\nREPLACE(str,from_str,to_str)\n\nDescription\n-----------\n\nReturns the string str with all occurrences of the string from_str replaced by the string to_str. REPLACE() performs a case-sensitive match when searching for from_str. If any argument is NULL, the function returns NULL.\n\nExamples\n--------\n\nSELECT REPLACE('www.mariadb.org', 'w', 'Ww');\n+---------------------------------------+\n| REPLACE('www.mariadb.org', 'w', 'Ww') |\n+---------------------------------------+\n| WwWwWw.mariadb.org                    |\n+---------------------------------------+\n\nURL: https://mariadb.com/docs/server/reference/sql-functions/string-functions/replace-function