Created
May 15, 2013 02:53
-
-
Save wokamoto/5581347 to your computer and use it in GitHub Desktop.
[WordPress] SPAM コメントを強制的に全部消す SQL 文
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
delete from wp_comments | |
where comment_approved = 'spam'; | |
delete from wp_commentmeta | |
where not exists ( | |
select 'x' from wp_comments | |
where wp_comments.comment_ID = wp_commentmeta.comment_id | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment