So, I’ve taken over management of a WordPress site that hasn’t been maintained very well. We currently have approximately 12,000+ spam comments on various posts. The default UI isn’t very helpful at only being able to delete or unapprove 25 or so at a time. Is there a way to do this via SQL?
How to delete post comments from the database via SQL statement?
