Batch approve comments July 20, 2022 by Tarik Billa You can use this SQL query to approve all spam comments: UPDATE wp_comments SET comment_approved = 1 WHERE comment_approved = 'spam';