Use the following SQL commands to change the post_status for every post in your wp_posts database table. This command will do the bulk change and exclude Pages from being changed–remember to replace STATUS with draft, private, or publish.
UPDATE wp_posts SET post_status = 'STATUS' WHERE post_status != 'static';
If you have multiple authors and only want to do a bulk edit of just one author's post, you can use the following command, but remember to replace NUMBER with the correct ID number of the post_author.
UPDATE wp_posts SET post_status='STATUS' WHERE post_author='NUMBER';
Posted in: WordPress