[Plugin: Drafts Scheduler] Plugin to Bulk move published articles to draft

No need for a plugin. Simply select ALL on screen, then from the actions drop down, choose edit, then change the published status.

You can adjust the number of posts per screen from the SCREEN OPTIONS pulldown.

if you want to do all of them bulk you can in phpmyadmin with this sql line :

UPDATE wp_posts SET post_status = ‘draft’ WHERE (post_type =’post’ and post_status = ‘publish’) ;

*** warning this will set ALL posts to ‘draft’ status so make sure you are ABSOLUTELY CERTAIN you want to do this ?? ***

Excellent on the SQL Command aquapan! I just reversed it to set drafts to publish in a WP Network. Of course, I selected my table for the subweb and changed the prefix since I installed WP Better Security which changes the prefix of the table name. To reverse it just change swap out the words draft and publish making sure your other parameters are correct for your WP install.

Thank you!