Spam gathers in my WordPress comments by the thousands every day. It can get quite overwhelming to manage. Especially when attempting to delete the tens of thousands of comments Akismet marked as “Spam” at once. If you attempt to delete too many comments at once from the WordPress Dashboard, it will likely error out or even worse, crash your site.
Fortunately, there is an easier way to delete Spam comments. You can do this easily using a database SQL command. Most hosts use phpMyAdmin to manage databases, so I will use that as an example on how to do this.