Tuesday, May 15, 2012

WordPress: Set All Posts to Draft

The following sql code snippet will set all posts/entries in WordPress as draft.

UPDATE wp_posts
SET wp_posts.post_status = 'draft'
WHERE wp_posts.post_type ='post';

No comments :

Post a Comment