数据库清洗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>","");
posted @ 2020-06-08 18:05  锐庆  阅读(214)  评论(0)    收藏  举报