Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: [ Ссылка ]

Download our exclusive 10-Point WP Hardening Checklist: [ Ссылка ]
Bulk Delete WordPress Comments via MySQL | WP Learning Lab

DELETE FROM wp_comments WHERE comment_approved = '0';

In this tutorial I'm going to show you how to delete large quantities of WordPress spam comments using a single command in MySQL.

The first thing you'll need to do is get to your phpMyAdmin where you can enter SQL queries.

Note: You should perform a database backup before you run SQL queries. Changes to your database can't be undone, so in case something goes wrong you can restore the database using the backup.

Here's a tutorial that will show you how to backup all of your WordPress files and the MySQL database: [ Ссылка ]

Please log into your hosting account cPanel or admin area. Find the phpMyAdmin link and click it. Depending on your hosting provider, you may be asked to log in again. Once you're in the phpMyAdmin find your WordPress database on the left hand side.

Next, click on the SQL tab at the top of the page. On the next page you will see a field where you can enter SQL queries. Copy and paste the query from below into the field and then click on the Go button (left side of the page).

DELETE FROM wp_comments WHERE comment_approved = '0';

You will be asked to confirm that you want to execute the query by clicking Go again to mass delete WordPress comments. Please do so.

After a few seconds the query will be complete and all the comments on your website be removed.

I hope this information helps you! If you have any questions leave a comment below or ping me @WPLearningLab on Twitter.

--------------

If you want more excellent WordPress information check out our website where we post WordPress tutorials daily.

[ Ссылка ]

Connect with us:

WP Learning Lab Channel: [ Ссылка ]

Facebook: [ Ссылка ]

Twitter: [ Ссылка ]

Google Plus: [ Ссылка ]

Pinterest: [ Ссылка ]

свернуть