Login

Example

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.

Syntax

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":

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

Example

Replace "X" with "m":

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

Example

Replace "x" with "m":

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

Login
ADS CODE