Title: Make all posts private
Last modified: August 18, 2016

---

# Make all posts private

 *  Resolved Anonymous
 * [21 years, 7 months ago](https://wordpress.org/support/topic/make-all-posts-private/)
 * I have a site and want to make the entries up until now private. Then I’ll make
   posts as usual and they’ll be the only ones that appear until a few months down
   the track where I’ll make all the private posts public again. What command would
   I have to run in phpmyadmin to make them all private, and then in the future 
   make them all public again?
    Cheers.

Viewing 6 replies - 1 through 6 (of 6 total)

 *  [midori](https://wordpress.org/support/users/midori/)
 * (@midori)
 * [21 years, 7 months ago](https://wordpress.org/support/topic/make-all-posts-private/#post-107779)
 * `UPDATE yourprefixfortables_posts SET post_status = 'private'` and the reverse:
   same, but = ‘publish’
 *  [midori](https://wordpress.org/support/users/midori/)
 * (@midori)
 * [21 years, 7 months ago](https://wordpress.org/support/topic/make-all-posts-private/#post-107781)
 * btw, there are many many informations here: [http://dev.mysql.com/doc/mysql/en/index.html](http://dev.mysql.com/doc/mysql/en/index.html)
 *  [major](https://wordpress.org/support/users/major/)
 * (@major)
 * [21 years, 7 months ago](https://wordpress.org/support/topic/make-all-posts-private/#post-107786)
 * Cool, just to make sure I have this 100% correct – mine would look like this 
   with a table prefix of ‘wp’:
    UPDATE wp_posts SET post_status = ‘private’
 *  [tiiimmt](https://wordpress.org/support/users/tiiimmt/)
 * (@tiiimmt)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/make-all-posts-private/#post-108387)
 * I just tried the reverse (ie publish) and PMA gave me an error.
 * “You have to choose at least one column to display”
 * I don’t get it. Why won’t PMA allow me to insert a simple query?
 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/make-all-posts-private/#post-108388)
 * If you have WordPress v2.0, try this plugin instead:
 * [http://blog.taragana.com/index.php/archive/angsumans-authenticated-wordpress-plugin-password-protection-for-your-wordpress-blog/](http://blog.taragana.com/index.php/archive/angsumans-authenticated-wordpress-plugin-password-protection-for-your-wordpress-blog/)
 * [http://codex.wordpress.org/Plugins/Restriction](http://codex.wordpress.org/Plugins/Restriction)
 *  [tiiimmt](https://wordpress.org/support/users/tiiimmt/)
 * (@tiiimmt)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/make-all-posts-private/#post-108389)
 * I don’t see how this is useful when all I want to do is have a query set all 
   my posts status to publish.
 * I have no idea why this doesn’t work:
    UPDATE wp_posts SET post_status = ‘publish’

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Make all posts private’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 6 replies
 * 5 participants
 * Last reply from: [tiiimmt](https://wordpress.org/support/users/tiiimmt/)
 * Last activity: [20 years, 5 months ago](https://wordpress.org/support/topic/make-all-posts-private/#post-108389)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics