用ralace(字段(字符串),‘被替代的字符’,‘要替代的字符’)
如REPLACE(f, s1, s2) returns the string f with all occurances of s1 replaced with s2
REPLACE('vessel','e','a') -> 'vassal'
用ralace(字段(字符串),‘被替代的字符’,‘要替代的字符’)
如REPLACE(f, s1, s2) returns the string f with all occurances of s1 replaced with s2
REPLACE('vessel','e','a') -> 'vassal'