批量替换表中某属性值 UPDATE `表名` SET `字段名` = REPLACE(`字段名`,'原值','新值'); 转载于:https://www.cnblogs.com/enone/p/5555988.html