Disable All Comments

Snippets by IsItWP

Do you want to automatically disable all comments from WordPress posts? By default, you need to manually disable comments from each post and it’ll take a lot of time. We have created a quick code snippet that you can use to disable all comments in WordPress.


All you have to do is to run these commands on your MySQL database to enable / disable all comments.

// Disable all comments
UPDATE wp_posts SET comment_status = 'closed', ping_status = 'closed';

// Enable all comments
UPDATE wp_posts SET comment_status = 'open', ping_status = 'open';

Note: If this is your first time adding code snippets in WordPress, then please refer to our guide on how to properly copy / paste code snippets in WordPress, so you don’t accidentally break your site.

If you liked this code snippet, please consider checking out our other articles on the site like: 27 best WordPress business themes for your website and 15 best content marketing tools and plugins for WordPress.

Comments   Leave a Reply

Add a Comment

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our privacy policy, and all links are nofollow. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

WordPress Launch Checklist

The Ultimate WordPress Launch Checklist

We've compiled all the essential checklist items for your next WordPress website launch into one handy ebook.
Yes, Send Me the Free eBook!