We all like the idea of getting a lot more traffic and comments on our blog, correct? One negative thing that comes along with more traffic is more spam. If you’ve ever tried to go in and delete large numbers of spam comments, you know it can take all day…a complete waste of time.
As always, a little knowledge can go a long way. This post is a short tutorial which shows you how I just deleted over 90,000 spam comments from a clients blog in just about one minute. A massive time saver to say the least 🙂
If you happen to be reading this post in a feed reader and cannot see the video, click here.
[jwplayer config=”YouTube” mediaid=”2253″]
This is the query I used in the video:
DELETE FROM wp_comments WHERE comment_approved = ‘0’
Feel free to copy and paste it if you like 🙂 If you have any questions, let me know. It’s my pleasure to help however I can!