How to Disable Comments on All Posts in Wordpress

How to Disable Comments on All Posts in Wordpress

Getting lots of queries asking about how to disable comments on all posts at once in Wordpress. So here is a simple SQL query which do this job like a charm.

Just pass the following SQL query either from Terminal or Web Based Database Manager (phpMyAdmin)

UPDATE wp_posts SET comment_status = 'closed';

Thanks Jeff Starr for the tip.

Navin
January 26, 2011 13:28 PM

Thanks, It helped me to block comments on our company blog.

Leave a Reply