{"id":228,"date":"2009-09-26T17:14:00","date_gmt":"2009-09-26T17:14:00","guid":{"rendered":"http:\/\/www.PressGold.com\/wordpress\/how-to-delete-all-those-spam-comments\/"},"modified":"2009-09-26T17:14:00","modified_gmt":"2009-09-26T17:14:00","slug":"how-to-delete-all-those-spam-comments","status":"publish","type":"post","link":"https:\/\/mohsinrasool.com\/how-to-delete-all-those-spam-comments\/","title":{"rendered":"How to Delete All Those Spam Comments"},"content":{"rendered":"<p>This is very risky to leave your WordPress blog open for all comment spam without adding any anti comment spam plugins.<\/p>\n<p>This was the case with the blog which a client of us have, it had about 4000 spam comments, and it was going to take ages to delete them all from WordPress dashboard. So they came to us for the help.<\/p>\n<p>We deleted all those about 4000 spam comment using little query operation at database level from <strong>phpmyadmin<\/strong>. I want to share the same process with you.<\/p>\n<p><strong>1.<\/strong> You need to login to your hosting panel and access PhpMyAdmin to access your database for that blog.<\/p>\n<p><strong>2.<\/strong> When you are there, select your blog\u2019s database and then click <strong>SQL <\/strong>tab and run the following query:<\/p>\n<p><em><font color=\"#004080\">DELETE FROM wp_comments WHERE comment_approved = 0<\/font><\/em><\/p>\n<p><strong>3.<\/strong> Wow within milliseconds all spam comment junk is gone.<\/p>\n<p><font color=\"#0080ff\"><strong>Deleted rows: 3994 (Query took 0.1472 sec)<\/strong><\/font><\/p>\n<p>Now go to your wordpress blog and see all pending(spam) comments are gone. Now you please add some anti spam plugins to stop this thing happening again. I recommend you activate built-in plugin for comment spam called <strong>akismet. <\/strong>And add any other anti spam plugin you may like.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is very risky to leave your WordPress blog open for all comment spam without adding any anti comment spam plugins. This was the case with the blog which a client of us have, it had about 4000 spam comments, and it was going to take ages to delete them all from WordPress dashboard. So [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[6,10,14],"tags":[40,50,144,165,168],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pLoVR-3G","_links":{"self":[{"href":"https:\/\/mohsinrasool.com\/wp-json\/wp\/v2\/posts\/228"}],"collection":[{"href":"https:\/\/mohsinrasool.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohsinrasool.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohsinrasool.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohsinrasool.com\/wp-json\/wp\/v2\/comments?post=228"}],"version-history":[{"count":0,"href":"https:\/\/mohsinrasool.com\/wp-json\/wp\/v2\/posts\/228\/revisions"}],"wp:attachment":[{"href":"https:\/\/mohsinrasool.com\/wp-json\/wp\/v2\/media?parent=228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohsinrasool.com\/wp-json\/wp\/v2\/categories?post=228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohsinrasool.com\/wp-json\/wp\/v2\/tags?post=228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}