Physically Delete all Blog Posts by a Certain User

[Dustin L.]

I used the following SQL query to remove all blog-posts by a spammer who had registered while I was asleep and created 380 blog-posts.

As always, back-up your database before running this.

DELETE FROM `yourdatabasename`.`yourprefix_blog` WHERE `yourprefix_blog`.`username` = 'nameofuser'

You should run this in phpMyAdmin, through the MySQL CLI, or your choice of UI for managing MySQL.

Make sure to replace "yourdatabasename" with the name of your database, and "yourprefix" with your configured table-prefix, if any.



Dustin