REPLACE()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Returns the string str with all occurrences of the string from_
EXAMPLES
SELECT REPLACE('mcricdb', 'c', 'a');
+------------------------------+
| REPLACE('mcricdb', 'c', 'a') |
+------------------------------+
| mariadb |
+------------------------------+
SELECT REPLACE('Mariad', 'd', 'DB');
+------------------------------+
| REPLACE('Mariad', 'd', 'DB') |
+------------------------------+
| MariaDB |
+------------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.