批量替换数据库中的超链接

//批量替换数据库中的超链接
update ecs_goods set goods_desc =
replace(goods_desc,
substring(goods_desc,locate(‘<a ‘, goods_desc),locate(‘>’, goods_desc,locate(‘<a ‘, goods_desc))+1-locate(‘<a ‘, goods_desc)
),
”);
update ecs_goods set goods_desc =
replace(goods_desc,'</a>’,”);