Here is a method to mass delete spam comment in wordpress using phpMyAdmin and by using a plugin.
You can mass delete spam comments, approved comments, un approved comments and trash comments with just one click.
You can use this plugin to delete comments…WPCommentCleaner
(@rubya)
11 years, 4 months ago
Hi
I am trying to delete all these spam comments. I changed Screen Options to show 999 Comments. When I select all the comments and choose bulk move to trash I get this error:
Request-URI Too Large
The requested URL’s length exceeds the capacity limit for this server.
Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 mod_perl/2.0.4 Perl/v5.8.8 Server at cpanel14.per.syra.net.au Port 80
Please help me. There is 2000 spam comments I need to delete