How to Delete All Comments on WordPress Manually, Using a Plugin, and More

WordPress is a great platform for creating and managing websites. It also allows you to easily manage comments on your website. However, if you want to delete all comments on WordPress, there are several ways to do it.

Manually Deleting All Comments

The simplest way to delete all comments on WordPress is to do it manually. To do this, go to the “Comments” section of your WordPress dashboard. Here, you will see a list of all the comments on your website. You can then select the comments you want to delete and click the “Delete” button.

Using a Plugin

If you don’t want to delete all comments manually, you can use a plugin to do it for you. There are several plugins available that can help you delete all comments on WordPress. Some of the most popular plugins include WP-Optimize, WP-Sweep, and WP-Cleaner.

Using a Bulk Delete Tool

Another option is to use a bulk delete tool. These tools allow you to select multiple comments and delete them all at once. Some of the most popular bulk delete tools include WP-Bulk Delete and WP-Delete All Comments.

Using a Database Query

If you’re comfortable with writing SQL queries, you can also delete all comments on WordPress using a database query. To do this, you will need to access your WordPress database and run a query to delete all comments.

Using a Script

Finally, you can also use a script to delete all comments on WordPress. This is a more advanced option and requires some coding knowledge. However, if you’re comfortable with coding, you can use a script to delete all comments on WordPress.

No matter which method you choose, deleting all comments on WordPress is a relatively simple process. Whether you choose to do it manually, use a plugin, or use a script, you can easily delete all comments on your website.

Having comments on a website is a great way to engage your audience. Unfortunately, it’s also one of the many platforms that hackers can use to fill your site with spam and malicious content. This article will show how to delete all comments on WordPress.

We will go over why deleting comments may be necessary, as well as three different methods to remove all comments on your WordPress website.

Although comments can help build relationships with the audience, there are times when you need to remove them from your WordPress site. An example is when you need to get rid of spam messages, which is common among websites without an anti-spam setup. 

These comments can harm user experience and WordPress search engine optimization (SEO) rankings. Furthermore, they can pose security threats as they may contain malicious content or direct visitors to an unsecured website.

The following sections will list three ways to remove all comments on your WordPress site – from the easiest to the most difficult. Which method you choose depends on your preferences and technical knowledge.

Use the WordPress Admin Dashboard

The most straightforward way to delete all comments on WordPress is to log in to your admin dashboard and navigate to the Comments page. Follow these steps:

  1. Select Comments on the left menu.
    How to delete all WordPress comments from WordPress dashboard
  2. Find the Bulk Actions dropdown menu and choose Move to Trash. Select all comments and click Apply.
    This image shows you how to delete all comments in WordPress from the platform's Comments section.

Use a WordPress Plugin

Another option is to install a WordPress plugin specifically for removing multiple WordPress comments simultaneously. WP Bulk Delete is a great option for this, as it can implement filters and conditions when managing comments based on your needs.

The free version of the plugin comes with a primary comment remover feature. For more filter options, check out the Pro plan for $29/site

Follow these steps to remove all comments with WP Bulk Delete:

  1. Head to the WordPress admin dashboard and navigate to WP Bulk Delete -> Delete Comments.
    access to WP Bulk Delete menu
  2. Check the filters you want to use and click Delete Comments. The free version lets you filter comments based on their status and publication date.
    This image shows WP Bulk Delete's comment deletion settings.

Use phpMyAdmin

Finally, you can delete all WordPress comments directly from your database using phpMyAdmin. Consider this method if the admin panel or plugin method isn’t working properly. That being said, it requires some basic knowledge of databases and SQL. 

There are two options to delete comments using phpMyAdmin – running an SQL query or emptying the comment table. Both methods will modify two tables where comments take place, wp_comments and wp_commentmeta.

Important! The tables’ names might differ depending on your database prefix.

Your database is accessible from your web hosting control panel. 

The tutorial below will show you how to delete all WordPress comments using an SQL query from Hostinger’s hPanel. This method is suitable if you have specific types of comments to remove.

1. From your hPanel, head to Databases → phpMyAdmin and choose the database you want to modify. Click Enter phpMyAdmin.

The phpMyAdmin page on the hPanel

2. In phpMyAdmin, select the wp_comments table.

This image shows you how to access wp_comments from phpMyAdmin.

3. Click on the SQL tab at the top to open the SQL query window.

This image shows you how to access the SQL query tab of the selected table.

4. Choose one of the following queries to delete comments based on particular conditions:

Delete all WordPress non-approved and pending comments:

DELETE from wp_comments WHERE comment_approved =  '0' 

Delete all WordPress approved comments:

DELETE from wp_comments WHERE comment_approved =  '1' 

Delete all WordPress trash comments:

DELETE from wp_comments WHERE comment_approved =  'trash' 

Delete all WordPress spam comments:

DELETE from wp_comments WHERE comment_approved =  'spam'

5. Add the chosen query to the SQL query window, then click Go. Repeat this step several times according to the number of queries you want to execute.

This image shows you how to execute the SQL query.

6. Repeat the entire steps to remove comments from the wp_commentmeta table.

If you want to delete all WordPress comments unconditionally, you can follow these steps:

  1. In phpMyAdmin, tick wp_comments and wp_commentmeta’s respective boxes to the left.
  2. Find the With selected dropdown menu and select Empty.
    This image shows you how to automatically generate SQL query to empty wp_comments and wp_commentmeta tables.
  3. Click Yes to confirm that you want to execute the presented queries.

Conclusion

Comments play an essential role in growing your audience, but some situations may deem it necessary to purge them. Some comments can harm your site’s SEO and user experience.

Therefore, this article has shown how to delete all comments on WordPress:

  • Using the WordPress admin dashboard. The most straightforward option. However, there’s no ability to filter the comments. 
  • Using the WP Bulk Delete plugin. The simplest and most flexible option as it offers the option to filter the comments.
  • Using SQL queries in phpMyAdmin. This method requires technical knowledge but offers more control over the deletion process.

As each method has its pros and cons, it’s best to consider your needs before deciding. We recommend doing a test run on a couple of WordPress comments first to see which method best suits your preferences.

How to Delete All Comments on WordPress Manually, Using a Plugin, and More

WordPress is a powerful content management system that allows you to easily manage your website’s content. One of the features of WordPress is the ability to allow visitors to leave comments on your posts and pages. However, if you want to delete all comments on WordPress, you have several options.

Manually Deleting All Comments

The simplest way to delete all comments on WordPress is to do it manually. To do this, go to the “Comments” section of your WordPress dashboard. Here, you will see a list of all the comments that have been left on your website. You can select the comments you want to delete and then click the “Delete” button.

Using a Plugin to Delete All Comments

If you don’t want to delete all comments manually, you can use a plugin to do it for you. There are several plugins available that allow you to delete all comments on WordPress with just a few clicks. These plugins are easy to install and use, and they can save you a lot of time.

Deleting Comments from the Database

If you want to delete all comments from the database, you can do so by accessing your WordPress database. This is a more advanced method and should only be done by experienced users. To do this, you will need to access your database using a program like phpMyAdmin. Once you have accessed the database, you can delete all comments from the “wp_comments” table.

Deleting Comments from the Front End

If you want to delete all comments from the front end of your website, you can do so by using a plugin. There are several plugins available that allow you to delete comments from the front end of your website. These plugins are easy to install and use, and they can save you a lot of time.

Conclusion

Deleting all comments on WordPress is easy to do, and there are several methods you can use. You can delete all comments manually, use a plugin, delete comments from the database, or delete comments from the front end of your website. Whichever method you choose, you can easily delete all comments on WordPress.

jassweb logo

Jassweb always keeps its services up-to-date with the latest trends in the market, providing its customers all over the world with high-end and easily extensible internet, intranet, and extranet products.

Contact
Jassweb, Rai Chak, Punjab, India. 143518