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

enter image description here

henry 1 year 2021-12-08T23:03:19-05:00 0 Answers 0 views 0

Leave an answer