Sql模糊替换字段内某个值：
update table1 set name = replace(name , '张三' ,'张小三') where name like '%张三%'
update table1 set name = replace(name , '张三' ,'张小三')
where name like '%张三%'