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?