MySQL REPLACE() function – w3resource
REPLACE() function MySQL REPLACE() replaces all the occurrences of a substring within a string. Syntax: REPLACE(str, find_string, replace_with) Arguments: Name Description str A string. find_string A string which is present…