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 one or more times within the string str. |
| replace_with | A string which will replace every time it finds find_string within str. |
REPLACE(str,old_string,new_string);
About Author
