Quickly mass delete pending comments from an ExpressionEngine database.

Ever get bombarded by a spammer in your ExpressionEngine comment system and want to delete, say 16,747 pending comments all at once? Run the following query on your MySQL database and kiss that spam goodbye. (Please, make a backup on your database before doing this though!)

DELETE
FROM exp_comments
WHERE exp_comments.`status` = 'p';

Spam be gone.

There are no comments to this post.

Leave Your Comment:

name:

email:

location:

url:

your comment:

Remember my personal information

Notify me of follow-up comments?

Twitter Feed

John Morton talking on Twitter




Meanwhile on Instagram… //

My latest shot from Instagram.
#nyc