Title: SQL Open Comment?
Last modified: August 18, 2016

---

# SQL Open Comment?

 *  [lawtai](https://wordpress.org/support/users/lawtai/)
 * (@lawtai)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/sql-open-comment/)
 * I’d like to be able to open up my old comments which I had auto closed after 
   X amount of days. What command can I type into myphpadmin to run SQL setting 
   the comment status to open?

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

 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/sql-open-comment/#post-183784)
 * `UPDATE wp_posts SET comment_status="open";`
 *  Thread Starter [lawtai](https://wordpress.org/support/users/lawtai/)
 * (@lawtai)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/sql-open-comment/#post-183785)
 * Thanks macmanx! 🙂

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

The topic ‘SQL Open Comment?’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [lawtai](https://wordpress.org/support/users/lawtai/)
 * Last activity: [21 years, 2 months ago](https://wordpress.org/support/topic/sql-open-comment/#post-183785)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics