How can I do a bulk edit of the Status field for all the posts in my database?

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';

See also: