MySQL commands to delete spam WordPress comments & commentmeta
delete from wp_comments where comment_approved='spam'; | |
delete from wp_commentmeta where comment_id not in (select comment_id from wp_comments); | |
delete from wp_commentmeta where meta_key like '%akismet%'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment