WordPress Developer Tips: Deleting Spam Comments in the Database

with Morten Rand-Hendriksen
please wait ...
WordPress Developer Tips: Deleting Spam Comments in the Database
Video duration: 0s 33m 25s Advanced


WordPress sites are prime targets for spam comments. Left unchecked, thousands or even hundreds of thousands of spam comments will bog down your database. Luckily, there are plugins like Akismet to help. And even when the volume is too large to be cleaned up with Akismet, you can use some smart, simple SQL commands to remove all the spam from your database in minutes. Morten Rand-Hendriksen shows you how to perform both spam-sweeping steps in this course.



(light music) - [Voiceover] Hi I'm Morton Rand-Hendriksen, staff author at Lynda.com. And I'm excited to welcome you to WordPress Developer Tips: Deleting Spam from the Databsase. In this advanced developer course, we'll look at how you can use simple sequel queries to delete spam and other types of comments directly from the database, without having to go through the Wordpress admin interface. We'll start out by looking at how you can protect your site from ever getting a spam problem.

Then I'll walk you through the process of identifying the different types of content within the database you need to change. We'll run queries on the different tables to first delete the comments and then delete comment's meta. And finally, I'll show you some different queries you can use to target different types of comments, either published, pending, trashed, or spam. So let's get cracking with Wordpress Developer Tips: Deleting Spam from the Database.

please wait ...