update `表名` set 字段名 =replace(字段名, '查找的内容','更改的内容') where 字段名 like '%查找的内容%';
update shangpin set click_url=replace(click_url,'21508360','1111111111') where click_url like '%21508360%';
本文共 237 字，大约阅读时间需要 1 分钟。
update `表名` set 字段名 =replace(字段名, '查找的内容','更改的内容') where 字段名 like '%查找的内容%';
update shangpin set click_url=replace(click_url,'21508360','1111111111') where click_url like '%21508360%';
转载于:https://www.cnblogs.com/liuxinfei/p/5091451.html