mysql 批量替换 内容

mysql批量替换字段内容语法:

UPDATE 表名 SET 字段 = REPLACE(字段,"原内容","替换内容") WHERE 条件;
//支持多字段
UPDATE 表名 SET 字段 = REPLACE(字段,"原内容","替换内容") , 字段 = REPLACE(字段,"原内容","替换内容") WHERE 条件;
//例子：
UPDATE ecs_goods SET goods_name = REPLACE(goods_name,"企业网站","php企业网站源码") 

update teach set contentflv=replace(contentflv,'192.168.1.41','211.99.224.138');