下面是在官网上摘抄下来的
translate只能是单个字符一对一的替换,replace是字符串的替换,并能删除
REPLACE
provides functionality related to that provided by the TRANSLATE
function. TRANSLATE
provides single-character, one-to-one substitution. REPLACE
lets you substitute one string for another as well as to remove character strings.