Title: SQL question
Last modified: August 21, 2016

---

# SQL question

 *  Resolved [mtmquotesearch](https://wordpress.org/support/users/mtmquotesearch/)
 * (@mtmquotesearch)
 * [13 years ago](https://wordpress.org/support/topic/sql-question-2/)
 * I’m trying to update a lot of blog posts’ status at the same time. I found a 
   command:
 * UPDATE wp_posts SET post_status=’STATUS’;
 * but I have no idea how to actually use this command. Can someone help?
 * How do I access the SQL and how do i run this command?
 * If there is a link somewhere that i could just read, please post it.
 * Thanks so much!

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

 *  Thread Starter [mtmquotesearch](https://wordpress.org/support/users/mtmquotesearch/)
 * (@mtmquotesearch)
 * [13 years ago](https://wordpress.org/support/topic/sql-question-2/#post-3741964)
 * I figured out how to do it – but when i did so it actually deleted all my posts!
 * clearly it’s wrong. what should the SQL command be?
 *  Thread Starter [mtmquotesearch](https://wordpress.org/support/users/mtmquotesearch/)
 * (@mtmquotesearch)
 * [13 years ago](https://wordpress.org/support/topic/sql-question-2/#post-3742032)
 * I figured it out.
 * The other thread said to change it to PUBLIC, which was wrong. It should be PUBLISH

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

The topic ‘SQL question’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 1 participant
 * Last reply from: [mtmquotesearch](https://wordpress.org/support/users/mtmquotesearch/)
 * Last activity: [13 years ago](https://wordpress.org/support/topic/sql-question-2/#post-3742032)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics