Open Close All WordPress Comments using SQL Query

The Process:

1. First you need to log into your phpMyAdmin control applet

2. Now locate and select your WordPress database on the left from the database dropdown list

3. Now select the SQL tab from the navigation tabs at the top

4. Within the Run SQL Query box add the following code and click go:

UPDATE posts p SET comment_status = 'closed', ping_status = 'closed' WHERE comment_status = 'open';

5. If you get an error, check your wp_post prefix from the database list and change the code to match accordingly

If successful, you should have disabled the ability to comment on your posts across your entire blog.

To globally enable or re-enable comments, simply use the following code:

UPDATE posts p SET comment_status = 'open', ping_status = 'open' WHERE comment_status = 'closed';

PREVIOUS POST

NEXT POST