Title: Mass-Edit Posts
Last modified: August 18, 2016

---

# Mass-Edit Posts

 *  [tysontate](https://wordpress.org/support/users/tysontate/)
 * (@tysontate)
 * [20 years, 2 months ago](https://wordpress.org/support/topic/mass-edit-posts/)
 * Is there a way to change the “published” status of many posts at once? I’ve got
   several hundred posts I’d like to make private, but I don’t want to spent ten
   hours doing it manually. Perhaps there’s a plug-in?
 * I tired this one:
 * [http://www.coldforged.org/the-enhanced-view-plugin/](http://www.coldforged.org/the-enhanced-view-plugin/)
 * but it doesn’t work in 2.0.

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

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 2 months ago](https://wordpress.org/support/topic/mass-edit-posts/#post-346288)
 * There will be a way to make ALL posts private – find the table with the information
   and run an sql query to flip them all to private.
    But for only some ? Tricky–
   you would need them to be in blocks of dates and then run the queries. But individual
   posts would need doing by hand. Not easy.
 *  Thread Starter [tysontate](https://wordpress.org/support/users/tysontate/)
 * (@tysontate)
 * [20 years, 2 months ago](https://wordpress.org/support/topic/mass-edit-posts/#post-346378)
 * `UPDATE wp_posts SET post_status = 'private'`
 * That should work, right?

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

The topic ‘Mass-Edit Posts’ is closed to new replies.

## Tags

 * [many](https://wordpress.org/support/topic-tag/many/)
 * [mass](https://wordpress.org/support/topic-tag/mass/)

 * 2 replies
 * 2 participants
 * Last reply from: [tysontate](https://wordpress.org/support/users/tysontate/)
 * Last activity: [20 years, 2 months ago](https://wordpress.org/support/topic/mass-edit-posts/#post-346378)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics