SQL command to delete “pending comments” doesn’t work…?
This is the SQL command:
DELETE FROM wp_comments WHERE comment_approved = 0
This, as you can see in the screenshot below, says that the operation was executed ok but no rows affected….which is odd b/c I have 13,000 pending comments that I am trying to delete!
Any idea what I might be doing wrong?
There is a plugin that does this but it crashes when I use it – most likely b/c I have 13K comments that need deleting from the pending state…
Thanks for all help