sql replace syntax
To replace all occurrences of a substring within a string with a new substring, you use the REPLACE() function as follows:
REPLACE(input_string, substring, new_substring);
Code language: SQL (Structured Query Language) (sql)
In this syntax:
input_string is any string expression to be searched.
substring is the substring to be replaced.
new_substring is the replacement string.
The REPLACE() function returns a new string in which all occurrences of the substring
are replaced by the new_substring. It returns NULL if any argument is NULL.