REPLACE ( str, from_str, to_str )
str:需要被修改的字符串
from_str:要被替换的子字符串
to_str :新的子字符串
SELECT REPLACE("小猫咪小猫咪","猫咪","狗")
运行结果:小狗小狗
REPLACE ( str, from_str, to_str )
str:需要被修改的字符串
from_str:要被替换的子字符串
to_str :新的子字符串
SELECT REPLACE("小猫咪小猫咪","猫咪","狗")
运行结果:小狗小狗