REPLACE() FUNCTION in MySQL
REPLACE() FUNCTION The MySQL REPLACE function is used to replace all occurrences of a substring in a string. The various versions of MySQL support the REPLACE function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: REPLACE( string, from_substring, to_substring ) Parameters: string: It is … Read more