update

update `表名` set 字段名 =replace(字段名, '查找的内容','更改的内容') where 字段名 like '%查找的内容%';

update shangpin set click_url=replace(click_url,'21508360','1111111111') where click_url like '%21508360%';

posted @ 2015-12-31 13:32  剑飞不了情  阅读(153)  评论(0编辑  收藏  举报