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;
|