数据库清洗html标签

原生sql清洗字段的html标签

update special_pack set intro = replace(intro,"<br />","");
update special_pack set intro = replace(intro,"<br>","");
update special_pack set intro = replace(intro,"<p>","");
update special_pack set intro = replace(intro,"</p>","");
update special_pack set intro = replace(intro,"</div>","");
update special_pack set intro = replace(intro,"<div>","");