I have found a solution!
Instead of making the comment_approved field to ‘1’ change them all to ‘0’, that is,
UPDATE wp_comments SET comment_approved = ‘0’ WHERE comment_approved = ”
Then they will all appear in the “awaiting moderation” section, then do a approve all! All my 2000 comments appears in the post with the comment count correctly showing in every post!!!
