Title: Edit in phpMyAdmin?
Last modified: August 19, 2016

---

# Edit in phpMyAdmin?

 *  [elfraser](https://wordpress.org/support/users/elfraser/)
 * (@elfraser)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/edit-in-phpmyadmin/)
 * Hey,
    I’m savvy but not amazing and new to phpMyAdmin and SQL. My goal is to 
   classify a number (all, actually) of my posts as private. When in the wp_posts
   table, the relevant field is post_status. I can do a search and sort by this 
   field, but what I want to do is change the values of the rows to set them to 
   have a specific value (‘private’ from ‘publish’).
 * Anyone know how? I’m sure it’s simple but I’m green…

Viewing 1 replies (of 1 total)

 *  Thread Starter [elfraser](https://wordpress.org/support/users/elfraser/)
 * (@elfraser)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/edit-in-phpmyadmin/#post-958070)
 * nm guys. got it!
    `UPDATE wp_posts SET post_status='private' WHERE post_status
   ='public'`

Viewing 1 replies (of 1 total)

The topic ‘Edit in phpMyAdmin?’ is closed to new replies.

## Tags

 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [posts](https://wordpress.org/support/topic-tag/posts/)
 * [private](https://wordpress.org/support/topic-tag/private/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 1 participant
 * Last reply from: [elfraser](https://wordpress.org/support/users/elfraser/)
 * Last activity: [17 years, 4 months ago](https://wordpress.org/support/topic/edit-in-phpmyadmin/#post-958070)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics