西部数码主机 | 阿里云主机| 虚拟主机 | 服务器 | 返回乐道官网
当前位置: 主页 > php教程 > zencart教程 >

Zen Cart批量删除垃圾评论

时间:2017-01-01 17:15来源:未知 作者:好模板 点击:
en Cart V1.39h 被人狂发垃圾评论 决心清理一下 请注意:操作前请务必备份数据库。 delete t1,t2 from reviews as t1 left join reviews_description as t2 on t1.reviews_id=t2.reviews_id where t1.status=0 AND t2.reviews_
en Cart V1.39h 被人狂发垃圾评论 决心清理一下
 
请注意:操作前请务必备份数据库。
 
 
delete t1,t2 from reviews as t1 left join reviews_description as t2 on t1.reviews_id=t2.reviews_id where t1.status=0 AND t2.reviews_text like "%href%" OR t2.reviews_text like "%http%";
 
 
delete t1,t2 from reviews as t1 left join reviews_description as t2 on t1.reviews_id=t2.reviews_id where t1.status=0 AND t2.reviews_text like "%href%" OR t2.reviews_text like "%http%" OR t1.customers_name is null;
删除指定id 的评论
 
 
delete t1,t2 from reviews as t1 left join reviews_description as t2 on t1.reviews_id=t2.reviews_id where t1.reviews_id=4423;
 
(责任编辑:好模板)
顶一下
(1)
100%
踩一下
(0)
0%
------分隔线----------------------------
栏目列表
热点内容