MySQL REPLACE() Function
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
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
