Here is way to manage your wordpress comments using php mysql queries.<\/p>\n
wp_<\/code>\u00a0by the one used by your database.<\/li>\n<\/ul>\nDelete all spam comments<\/h2>\n
When you have over 100,000 spam comments in your spam queue, deleting them using the built-in \u201cdelete all spam\u201d button might result in a PHP memory error. To avoid this, just use this simple SQL request to delete all spam at once.<\/p>\n
DELETE from wp_comments WHERE comment_approved = 'spam'<\/pre>\nDelete all comments between two dates<\/h2>\n
Had a \u201cspam attack\u201d for a limited time? Here is an easy way to delete all comments between two dates.<\/p>\n
DELETE FROM wp_comments \r\nWHERE comment_date > '2013-11-15 01:10:04'\r\nAND comment_date <= '2013-11-20 00:10:04'<\/pre>\nDelete all pending comments<\/h2>\n
If your “pending comment” queue is filled with 99% spam comments and you don’t want to manually review each of them, here is a SQL command to instantly erase all pending comments.<\/p>\n
DELETE FROM wp_comments WHERE comment_approved = '0'<\/pre>\nDisable comments on all posts at once<\/h2>\n
Want to disable comments on all of your posts? Instead of closing comments on all your posts the one after the other, why not using this super simple SQL query?<\/p>\n
UPDATE wp_posts SET comment_status = 'closed', ping_status = 'closed' WHERE comment_status = 'open'<\/pre>\nDisable comments on older posts<\/h2>\n
To limit spam, why not closing comments on older posts? Here is the SQL to automatically close comments on all posts older than January 1, 2014:<\/p>\n
UPDATE wp_posts SET comment_status = 'closed' WHERE post_date < '2014-01-01' AND post_status = 'publish'<\/pre>\nSource:\u00a0http:\/\/perishablepress.com\/wordpress-discussion-management…<\/a><\/strong><\/p>\ndelete comments with a specific url<\/h2>\n
Even if you’re careful when approving new comments, sometimes you might just forget to visit the commenter url and detect a long time after that the linked site is spammy. Here is a very easy way to bulk delete all comments with a specific url, using a simple SQL query.<\/p>\n
DELETE from wp_comments WHERE comment_author_url LIKE \"%nastyspamurl%\" ;<\/pre>\n