a fairly quick way to do it
download this plugin
http://wordpress.org/extend/plugins/wp-db-backup/
install it and do a database back up with it
choose the option to exclude spam comments
download the back up
now import the backup
http://codex.wordpress.org/Restoring_Your_Database_From_Backup
spam gone
Hi,
YOu can execute this query to delete all spam comments at once:
delete from wp_comments where comment_approved = ’spam’;
Thanks,
Shane G.
(@imsoper)
15 years, 11 months ago
I’m working on a client’s blog that currently has 9,900 comments pending (most, obviously are spam). I’ve installed Akismet and want to somehow automatically irradicate the spam comments. I tried to use “Check for Spam” button, but that doesn’t do anything, it takes me to a blank screen.
Does anyone know a way of automatically going through a LARGE number of comments and mark them as spam?