THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL REPLACE() Function

❮ MySQL Functions

Example

Replace "SQL" with "HTML":

SELECT REPLACE("SQL Tutorial", "SQL", "HTML");
Try it Yourself »

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, from_string, new_string)

Parameter Values

Parameter Description
string Required. The original string
from_string 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");
Try it Yourself »

Example

Replace "X" with "m":

SELECT REPLACE("XYZ FGH XYZ", "X", "m");
Try it Yourself »

Example

Replace "x" with "m":

SELECT REPLACE("XYZ FGH XYZ", "x", "m");
Try it Yourself »

❮ MySQL Functions