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.
This site uses cookies and services for collecting technical data of visitors (data about IP-address, location, etc.) to ensure performance and improve the quality of service. By continuing to use our site, you automatically agree to the use of these technologies.Confirm your consent by clicking OK. If you do not agree, please leave the site.