update ecs_goods set goods_desc=replace (goods_desc,'http://cqwscs.3322.org','http://www.1jiachun.com') where goods_id=86
函数参数说明:
replace (goods_desc,'http://cqwscs.3322.org','http://www.1jiachun.com')
goods_desc字段 'http://cqwscs.3322.org'要替换的内容 'http://www.1jiachun.com'替换成的内容
这里一定要注意第一个参数 字段名不能带引号