REPLACE():
This function takes a string along with a specified word or character to be replaced, and returns a new string where the specified part is substituted with the new value provided as an argument.
Syntax:
REPLACE(string, old_substring, new_substring)
Example:
SELECT REPLACE('SQL Tutorial', 'SQL', 'MySQL') AS Result;
Output:
MySQL Tutorial