MySQL REPLACE() Function

Replace "SQL" with "HTML":

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.

REPLACE( string, substring, new_string)

Parameter	Description
string	Required. The original string
substring	Required. The substring to be replaced
new_string	Required. The new replacement substring

Works in:	From MySQL 4.0

Replace "X" with "M":

SELECT REPLACE("XYZ FGH XYZ", "X", "M");

Replace "X" with "m":

SELECT REPLACE("XYZ FGH XYZ", "X", "m");

Replace "x" with "m":

SELECT REPLACE("XYZ FGH XYZ", "x", "m");