Skip to content

Instantly share code, notes, and snippets.

@fabiotatsuo

fabiotatsuo/gist:f78a79a69535b178c679fda2417b3720

Last active July 13, 2017 01:43
Show Gist options
  • Save fabiotatsuo/f78a79a69535b178c679fda2417b3720 to your computer and use it in GitHub Desktop.
Save fabiotatsuo/f78a79a69535b178c679fda2417b3720 to your computer and use it in GitHub Desktop.
Download ZIP
Remove spam on wordpress approved comments
Raw
gistfile1.txt
SPAM Wordpress Comments
Check spam on approved comments
Install Askimet
Turn approved to pending
update wp_comments set comment_approved='0' WHERE comment_approved='1'
Run Askimet
Delete SPAM
Turn pending to approved
update wp_comments set comment_approved='1' WHERE comment_approved='0'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment