Example
Replace "SQL" with "HTML":
sql
SELECT REPLACE("SQL Tutorial", "SQL", "HTML");
Definition and Usage
The REPLACE() function replaces all occurrences of a substring within a string, with a new substring.
Note: This function performs a case-sensitive replacement.
Syntax
text
REPLACE(string, substring, new_string)
Parameter Values
| Parameter | Description |
|---|---|
| string | Required. The original string |
| substring | Required. The substring to be replaced |
| new_string | Required. The new replacement substring |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Replace "X" with "M":
sql
SELECT REPLACE("XYZ FGH XYZ", "X", "M");
Example
Replace "X" with "m":
sql
SELECT REPLACE("XYZ FGH XYZ", "X", "m");
Example
Replace "x" with "m":
sql
SELECT REPLACE("XYZ FGH XYZ", "x", "m");