Title: Close comments on all posts
Last modified: August 19, 2016

---

# Close comments on all posts

 *  [tfindlay](https://wordpress.org/support/users/tfindlay/)
 * (@tfindlay)
 * [15 years, 10 months ago](https://wordpress.org/support/topic/close-comments-on-all-posts/)
 * Is there a way to set “comments closed” for all posts rather than on a post by
   post basis?

Viewing 1 replies (of 1 total)

 *  [Joe Ponzio](https://wordpress.org/support/users/new-nine-media/)
 * (@new-nine-media)
 * [15 years, 10 months ago](https://wordpress.org/support/topic/close-comments-on-all-posts/#post-1621653)
 * For new posts: You can set comments closed as the default by going to _Settings_-
   >_Discussion_ and uncheck **Allow people to post comments on new articles**.
 * For existing posts: If you have access to your MySQL database, you can run this
   SQL code on the wp_posts table to change all posts to “closed” for new comments.(
   If you changed the prefix of the tables in your config file, look for the prefix_posts
   table.)
 * `UPDATE wp_posts SET comment_status='closed'`

Viewing 1 replies (of 1 total)

The topic ‘Close comments on all posts’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Joe Ponzio](https://wordpress.org/support/users/new-nine-media/)
 * Last activity: [15 years, 10 months ago](https://wordpress.org/support/topic/close-comments-on-all-posts/#post-1621653)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics