Bulk Delete WordPress Comments via MySQL | WP Learning Lab - Best Webhosting

ULTRAFAST, CHEAP, SCALABLE AND RELIABLE! WE STRONGLY RECOMMEND ACCU WEB HOSTING COMPANY

Watch Wordpress WPLearningLab Video: Bulk Delete WordPress Comments via MySQL | WP Learning Lab.
Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL
Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-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: https://youtu.be/cfLFO7kiS2Y

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.

http://wplearninglab.com/

Connect with us:

WP Learning Lab Channel: http://www.youtube.com/subscription_center?add_user=wplearninglab

Facebook: https://www.facebook.com/wplearninglab

Twitter: https://twitter.com/WPLearningLab

Google Plus: http://google.com/+Wplearninglab

Pinterest: http://www.pinterest.com/wplearninglab/

Published: Saturday, August 10, 2019 8:43 AM
Category: Wordpress WPLearningLab

90 Views

Related Videos

Popular
How to Easily Bulk Delete WordPress Posts on Your Site

by Best Webhosting Added 4 years ago 112 Views / 0 Likes

Trying to delete multiple WordPress posts in bulk? WordPress has built-in tools to help manage multiple posts but selecting and deleting them can take some time. In this video, we'll show you some of our recommended ways to handle bulk deleting posts in WordPress! The first method will be using the built-in WordPress method in the Posts, All Posts page. You would want to check the box next to the post you are wanting to delete or click the check at th
How To Bulk Delete Duplicate Files From Your WordPress Website Media Library? Clean Up Cloned Images

by Best Webhosting Added 1 year ago 13 Views / 0 Likes

In today's WordPress video tutorial we'll learn hoe to delete and clean up duplicated media files from our WordPress library in a bulk, simple, fast and for free. Download WordPress theme for free https://visualmodo.com/ How To Reset WordPress In Dashboard? Easy Method https://www.youtube.com/watch?v=4PwbMZmkWOg Automated 90+ PageSpeed Score For WordPress Websites Easily & Free With 10Web https://www.youtube.com/watch?v=d8k6NT7fHBs Looking to clean up
WordPress Comments - 3 Ways To Reply To Comments Inside WordPress | WP Learning Lab

by Best Webhosting Added 4 years ago 100 Views / 0 Likes

Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist WordPress Comments - 3 Ways To Reply To Comments Inside WordPress | WP Learning Lab In this tutorial you will learn the 3 ways (and a bonus 4th way) to reply to any WordPress comment. This is for a stock WordPress installation. You can install WordPress comment plugin
How to Delete Comments in WordPress | Beginners Series

by Best Webhosting Added 3 years ago 48 Views / 0 Likes

How to delete comments in WordPress - in this quick beginners WordPress tutorial I show you how to remove comments in WordPress. The process is very simple and straight forward and generally just takes a moment to do. You are able to delete both spam and unwanted comments in just a few seconds! TMDHosting - Use coupon code: wpwithtom7 for a 7% discount! http://bit.ly/2ffslmn My website! http://wpwithtom.com/ Elementor: https://bit.ly/2Ct0I1U ElegantTh
How To BULK DELETE GOOGLE DOCS Files Simple & Easy?

by Best Webhosting Added 1 year ago 13 Views / 0 Likes

In today's video tutorial, we'll learn how to bulk delete google docs files easier, in a simple and fast method in order to organize your document folders. Google Docs To WordPress https://visualmodo.com/google-docs-to-wordpress-import-content-guide-with-mammoth/ How To Add Alt Title To WordPress Media To Rank In Google Images: SEO + Accessibility Tutorial 👨‍🦯 https://www.youtube.com/watch?v=GA8jRrXlGKI How To Completely Translate Pages Using Google C
How to Bulk Delete Pins on Pinterest - Social Media Usage Tutorial

by Best Webhosting Added 1 year ago 18 Views / 0 Likes

In today's video Social media tutorial we'll learn how to delete Pins from Pinterest in a bulk, in a simple, fast and effective method. Using Pinterest To Grow Your Website Traffic https://visualmodo.com/using-pinterest-to-grow-your-website-traffic/ WordPress Top-Header Widgets Usage Guide - Add Widgets Over The Site Menu https://www.youtube.com/watch?v=SjnFpWyOk0Q How To Add Social Sharing Buttons To WordPress For Free? https://www.youtube.com/watch?
Popular
How to Delete data from database using PHP MySQL | PHP Tutorials in Hindi

by Best Webhosting Added 4 years ago 112 Views / 0 Likes

PHP Tutorials for beginners in Hindi - Complete Guide with easy and simple method. In this PHP video tutorial series I have cover basic operations of PHP language, Insert, Select/View, Update and Delete. I tried to explain you in a very easy way, and I hope you will notice these are the easy tutorials on basics of PHP language. Insert, Select, Update and Delete Operations are also known as CRUD (Create, Retrieve, Update and Delete). I will cover all t
Popular
Create a MySQL Database for your WordPress Site via cPanel | WP Learning Lab

by Best Webhosting Added 4 years ago 105 Views / 0 Likes

Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist Create a MySQL Database for your WordPress Site via cPanel | WP Learning Lab Although this video specific to WordPress users, it is also a great MySQL beginners tutorial. You won't actually go into phpMyAdmin or interact with the database directly so there's no danger of breaking very much. The first thing you need we'll do in this MySQL tutoria
Completely Delete WordPress In Two Steps | WP Learning Lab

by Best Webhosting Added 4 years ago 91 Views / 0 Likes

Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Completely Delete WordPress In Two Steps | WP Learning Lab Believe it or not, there are some people who want to delete WordPress. Crazy, right? Turns out, there are some legit reasons to delete WordPress, like deleting an old development site or starting from scratch after a bad hack. There are two parts to deleting WordPress: deleting the files and deleting the database. I
How To Manually Backup WordPress MySQL Database, Files and Folders | WP Learning Lab

by Best Webhosting Added 4 years ago 73 Views / 0 Likes

How To Manually Backup WordPress MySQL Database, Files and Folders https://youtu.be/cfLFO7kiS2Y The other half of this tutorial, how to manually restore from a backup: https://www.youtube.com/watch?v=7RazMUnBFnQ&list=PLlgSvQqMfii4qdGkBEavOHwqRqEzhhk5d In this WordPress tutorial, I'm going to show you how to manually backup WordPress MySQL database, files and folders. Being able to backup your website is important because you will want to do this befor
Change DB Prefix WordPress Plugin - Secure Your WordPress MySQL Database | WP Learning Lab

by Best Webhosting Added 4 years ago 85 Views / 0 Likes

Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist Change DB Prefix WordPress Plugin - Secure Your WordPress MySQL Database | WP Learning Lab In this tutorial I'm going to show you how to use the Change DB Prefix WordPress plugin to improve MySQL database security. Anyone running a WordPress-based website needs to con
WordPress Comments Tutorial | WP Learning Lab

by Best Webhosting Added 4 years ago 97 Views / 0 Likes

Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist WordPress Comments Tutorial Visitors to your site are able to leave comments via the WordPress comment form (also known as the WordPress comment box) that appears on WordPress Posts and WordPress Pages by default. At some point in the near future, if not already, your blog will get comments. At the beginning there's a good chance that a lot of t