How to Replace Substrings

MySQL provides the following string replacement function:

select replace(fruit_name,’ap’,’AP’) from fruits;
Fruit_name
grAPe
APple
Orange
peach

IN THIS PAGE