Delete 18,000 WordPress Spam Comments At Once
Client with 4-year old WordPress site had accumulated 18,000+ non-approved spam comments. This tip from WPRecipes will delete all non-approved comments. Backup your database Log in to your phpMyAdmin account Select your WordPress blog database Run SQL: DELETE FROM wp_comments WHERE comment_approved = ‘0’; Original article on WPRecipes: Mark asked: How to batch deleting spam comments…