Learning PHP, MySQL, and JavaScript

Name

REPLACE()

Synopsis

REPLACE(str, from, to)

Returns the string str with all occurrences of the string from replaced with the string to. The search and replace is case-sensitive when searching for from. This code returns the string “Cheeseburger and Coke”:

SELECT REPLACE('Cheeseburger and Fries', 'Fries', 'Coke');