Delete All WP Comments by Comment Approved Status

, December 27, 2010

If you’re anything like me you’ve let a WordPress blog or two get out of hand when it comes to comment spam. Here’s an easy way to get rid of all of those spam comments using a simply MySQL query.

DELETE FROM `wp_comments` WHERE `comment_approved`='spam'

About the Author: