mysql 批量替换 内容?我的mysql中有很多：
http://www15.babidou.com/pic/2007/12/14/shenbuy/www.shenbuy.com/001
.................
http://www15.babidou.com/pic/2007/12/14/shenbuy/www.shenbuy.com/100
的数据。
我现在想替换为
http://www.shenbuy.com/images/shenbuy/www.shenbuy.com/001
.....................
http://www.shenbuy.com/images/shenbuy/www.shenbuy.com/100

请问如何使用SQL语句修改

update `ecs_goods` set `goods_img`='网址` where RIGHT(`goods_img`,3)='001';
update `ecs_goods` set `goods_img`='网址` where RIGHT(`goods_img`,3)='100';