Sep 13, 2018

How to Delete All Spam Comments from WordPress

DELETE FROM wp_comments WHERE comment_approved = 'spam';


For Multisite, 
DELETE FROM wp_#_comments WHERE comment_approved = 'spam';

You need to replace # with the ID of the site you wish to clean up.