CatchUpdates.com

Big Sale on SSL - Up to 49% Off

  • Home
  • Blogging Tips
  • SEO
  • WordPress
  • Technology
    • Techo-World
    • Computer Stuffs
  • Misc Updates
    • Life Style
    • Top 10 List
    • Entertainment
    • Latest Issues
  • Hot Deals & Offers
  • About Us
  • Write For Us

3 Easy Ways to Delete all Comments in WordPress Website

Last updated on April 30, 2016 By Selvan Tamilmani 1 Comment

  • 555shares
  • Share on Facebook
  • Share on Twitter
  • Reddit
  • WhatsApp

If you are a WordPress website owner and you do not get time to check your website regularly then you might know that it is a pain to get rid of unapproved comments. Also, there are some WordPress websites, which get more spam comments due to many reasons, and it becomes a tedious task to delete all comments at once. Unfortunately, there is no option available to clear all unapproved comments at one go and you have to go through each and every page to delete them. On the top of that, there is no option to increase the number of comments being displayed in a section to make the deleting process easier. You have to manually traverse through each comment on the page and delete them. If you feel that maintaining a website is so difficult then you can consult one good WordPress website development company to make this easy. You don’t need to worry any of the security issues which comes in the form of spam comments or hijacking your website.

delete all comments from your wordpress blog

There are solutions to this problem. In this article, we are giving you three easy ways to delete all comments at one go in your WordPress website.

Delete All Comments Through SSH

This method is for those who persons who have in-depth technical knowledge. You need to log in via SSH and use the command line. It is extremely easy to delete all the comments through this method.

You need to be more careful while making this operation because there are more chances to delete another table or DB if you provide a wrong table or DB name. Use the correct details in all the following commands to make the process easy and smooth.

Follow the below steps to delete all comments using SSH and during this operation, you will be asked to provide the password for the Database. So please keep it ready.

  1. Log in to your website server via SSH .To delete all the comments that you would want to delete at one go, type the following command in the command prompt:
    mysql -u DB_USERNAME -p DB_NAME -e “DELETE FROM wp_comments WHERE comment_approved = ‘1’;”
  2. Then if you wish to delete all the spam comments write the following command:
    mysql -u DB_USERNAME -p DB_NAME -e “DELETE FROM wp_comments WHERE comment_approved = ‘spam’;”
  3. Also, if you want to delete or remove the trash comments, then you can type the following command:
    mysql -u DB_USERNAME -p DB_NAME -e “DELETE FROM wp_comments WHERE comment_approved = ‘trash’;”
  4. Also, if you want to delete or remove the trash comments, then you can type the following command:
  5. mysql -u DB_USERNAME -p DB_NAME -e “DELETE FROM wp_comments WHERE comment_approved = ‘0’;”

delete all comments through-ssh

To Delete All Comments Through PHP Myadmin

You can delete comments using PHPMyAdmin. Follow the below steps if you are using cPanel as your control panel to manage all your websites. If not, below steps may vary through PHPMyAdmin.

  1. Log in with your personal credentials ‘username’ & ‘password’ to cPanel account and from here select phpMyAdmin in the database section.
  2. Select the name of your database from there and click on the SQL tab. A command prompt window will open.
  3. To delete all comments type the following SQL query in the command prompt:
    DELETE from wp_comments WHERE comment_approved = ‘0’;
  4. To delete all other approved comments, type the following command:
    DELETE from wp_comments WHERE comment_approved = ‘1’;
  5. To delete the spam comments, run the following query:
    DELETE from wp_comments WHERE comment_approved = ‘spam’;
  6. To delete or clear the trash comments, type the following command:
    DELETE from wp_comments WHERE comment_approved = ‘trash’;

delete all comments through-phpmyadmin

To Delete All Comments Using a Plugin

You can also delete all the comments with the help of plugins. There are a variety of plugins are available in the plugin directory to make your work relatively easier. In many case themes and plugins will make your website awesome.

For example, you can install ‘Delete All Comments’ plugin. After installing this plugin, in the comments section of WordPress, there would “Delete All Comments” should come up. When it opens, then click on that particular option and you will be asked if you want to delete all the comments. And after that, you could click on “delete all comments” option. All the pending comments will be get deleted. This is a much easier and faster way to delete all your comments from your WordPress website.

  • About
  • Latest Posts

Selvan Tamilmani

Selvan is a working partner for the company Pattronize InfoTech. He spends most of the time in internet to do research on SEO and guides lot of local people for their local business. You can find Selvan on Twitter, LinkedIn and Facebook.

Latest posts by Selvan Tamilmani (see all)

  • 3 Easy Ways to Delete all Comments in WordPress Website - April 30, 2016

Filed Under: WordPress Tagged With: Plugins

Comments

  1. Murali says

    May 3, 2016 at 3:13 pm

    Good write and very well explained

Leave a Reply Cancel reply

Best Affiliate Programs To Join

    AWeber   WP Engine
    ShareASale    Grammarly
   OptinMonster   SEMrush

Analyze Your Website

Hot Deals Available


Long Tail Pro Coupon Code

Use Long Tail Pro’s step-by-step system to discover thousands of profitable, targeted keywords and calculate Keyword Competitiveness for almost any niche. Get 39% discount for a lifetime on any Long Tail Pro Annually Billed Plan More Less
39% Off
ANNUAL39OFF Show Code

Long Tail Pro Coupon Code

×

Use Long Tail Pro’s step-by-step system to discover thousands of profitable, targeted keywords and calculate Keyword Competitiveness for almost any niche. Get 39% discount for a lifetime on any Long Tail Pro Annually Billed Plan

ANNUAL39OFF Copy ANNUAL39OFF
Go to Offer Page

StudioPress Pro Plus All-Theme Package

With the purchase of the Pro Plus Package you receive instant and unlimited access, plus support and updates, for all themes created by StudioPress. Plus, as an added bonus, the Pro Plus Package also includes additional themes from 3rd-party developers. Never go shopping for a premium WordPress theme again. And you get all of this for a one-time payment of: $499.95 More Less
$499.95 only
Get this Deal

Recommended Articles

Top 15 Ways To Make Money From Your Website
NameCheap Coupon – 20% Off On Shared Hosting & 40% OFF on VPS
The Ultimate Guide to Use Quora To Promote Your Website
50+ Best Genesis Child Themes For Your Blog
A Complete Guide On How To Increase Domain Authority
10 Reasons Why You Should Purchase Genesis Framework
Media.Net Review: Is It Best Alternative To Google AdSense?
15 Motivational Bollywood Songs To Inspire You
OptinMonster Plugin Reviews - Is It Best Email Subscription WordPress Plugin?
ShareASale Affiliate Program: Make Money With Affiliate Marketing
Why I Converted My Multi Niche Blog To Single Niche Blog ?
7 Best Paying Affiliate Programs in ShareASale To Join

Search

Contact Us| Privacy Policy | Sitemap | Disclaimer

Copyright 2013 - 2018 All Rights Reserved. Built on Genesis Framework. Hosted on NameCheap Hosting

  • 555shares
  • Facebook384
  • Twitter0
  • Google+5
  • LinkedIn4
  • Reddit1
  • StumbleUpon158
  • WhatsApp0
  • Pinterest2
We'd Love To keep In Touch

Join more than 3,000 subscribers who

get the best articles delivered to their inbox for free.

 

And don’t worry, we hate spam too!

You can unsubscribe anytime.

Invalid email address

No, I do not want to grow. Thank you

Thanks for subscribing! Please check your email for further instructions.
Subscribe to get Latest Updates directly to your Inbox
x
Invalid email address
Thanks for subscribing! Please check your email for further instructions.