update 表 set 字段= replace(字段,'原始字符','替换字符') 转载于:https://www.cnblogs.com/junys/archive/2012/02/06/2340164.html