MySQL REPLACE() Function

The REPLACE() function in MySQL is a powerful string manipulation tool that allows you to substitute all occurrences of a specific substring within a larger string.

REPLACE(): Definition and Usage

This function replaces all instances of a search string with a replacement string within the original string. Keep in mind that the replacement is case-sensitive; "SQL" will not be replaced if you search for "sql".

Syntax


REPLACE(string, from_string, new_string)

Parameter Values

Parameter	Description
`string`	The original string where you want to perform the replacement. This is required.
`from_string`	The substring you want to replace. This is required.
`new_string`	The substring that will replace all occurrences of `from_string`. This is required.

Examples

Replacing "SQL" with "HTML"

This demonstrates a simple replacement of one substring with another.

Syntax


SELECT REPLACE("SQL Tutorial", "SQL", "HTML");

Output


HTML Tutorial

Replacing "X" with "M" (Case-Sensitive)

This illustrates the case-sensitive nature of REPLACE(). Notice that only the uppercase "X" is replaced.

Syntax


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

Output


MYZ FGH MYZ

More Case-Sensitive Examples

These additional examples further highlight the case-sensitivity. "X" is not replaced with "m" because they are different cases.

Syntax


SELECT REPLACE("XYZ FGH XYZ", "X", "m"); --Example 1
SELECT REPLACE("XYZ FGH XYZ", "x", "m"); --Example 2

Output


XYZ FGH XYZ --Example 1
XYZ FGH XYZ --Example 2