The process of bulk deleting mass comments is pretty straight forward, first off start by signing into the cPanel of your facilitating hosting provider. It might differentiate between interfaces, yet it’ll have the same features, once logged in, you have to go your PHPmyadmin and discover the database that we require for this site. Be cautious don’t do this for some other database nested under another website, ensure you have the right database! Go up to the SQL tab, you can copy and paste this bit of code:(DELETE FROM wp_comments WHERE comment_approved = 0 )
This is simply requesting a function to the given database to erase ALL comments. Thats it! once you refresh the page your spammy comment will be eradicated.