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;