Batch approve comments

You can use this SQL query to approve all spam comments:

UPDATE wp_comments SET comment_approved = 1 WHERE comment_approved = 'spam';