REPLACE(str,from_str,to_str): Replace str with all occurrences of from_str to_str : REPLACE « String Functions « MySQL Tutorial

1. MySQL Tutorial
2. String Functions
3. REPLACE

REPLACE() performs a case-sensitive match when searching for from_str.

mysql>
mysql>
mysql> SELECT REPLACE('www.java2s.com', 'w', 'W');
+-------------------------------------+
| REPLACE('www.java2s.com', 'w', 'W') |
+-------------------------------------+
| WWW.java2s.com                      |
+-------------------------------------+
1 row in set (0.00 sec)

mysql>