07 June, 2012

How To Delete All Pending Comments from WordPress Blog

Anyone can comment on the article of your wordpress blog.If Your Blog is more famous and get a lot of traffic then you defiantly receive a lot of comments including SPAM on daily basis. It is very easy to delete SPAM comments by Login -> Dashboard -> Comments -> Spam and Clicking on “Delete All SPAM” button. But if you have comments in thousands then this is a problem to delete all comments that is on awaiting approval. Here is the solution to delete all pending comments form your wordpress blog very easily and just in few seconds.

  • Login in Your Hosting Control Panel and Click on myPhpadmin
  • After Clicking on myPhpadmin, you will see a screen like below shown picture. 

  • Select your Blog’s mySQL database Account, (You will see a list of tables within that database)
  • Now Click on SQL (it can be located at next tab of structure). After Clicking on SQL, you will see a related image as shown below.

  • Copy-past below given SQL command and click on Go
DELETE FROM wp_comments WHERE comment_approved = '0'

Now you will get a message saying something like “853 rows affected”.
You have successfully Removed All Pending Comments of your WordPress Blog. Now login to your wordpress blog and you will see that all pending comments have been removed.

Muhammad Shoaib have a good experience in the field of Blogging since decade. If you are a new blogger who just starts your blogging career then www.shoaibonline.com is the perfect place to learn about blogging.