Example
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
,
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 |
|---|