1、用法【子串替换/删除】
translate("absdefg","abcde","ss")
REGEXP_REPLACE("absdefg","abcde","ss")
均可输出 “ssfg”
2、区别
逐字符替换 & 连续字符替换
translate("景县景州镇","景县","")
-- 输出 "州镇"
REGEXP_REPLACE("景县景州镇","景县","")
-- 输出 "景州镇"
1、用法【子串替换/删除】
translate("absdefg","abcde","ss")
REGEXP_REPLACE("absdefg","abcde","ss")
均可输出 “ssfg”
2、区别
逐字符替换 & 连续字符替换
translate("景县景州镇","景县","")
-- 输出 "州镇"
REGEXP_REPLACE("景县景州镇","景县","")
-- 输出 "景州镇"