Database Query to Enable/Disable Comment Option For WordPress Blog

Hi,

We can enable/disable comment option from database also. For that we just need to execute simple query. Here it is:

1. Log into phpMyAdmin control panel.
2. Select WordPress database on the left from the database dropdown list.
3. Select the SQL tab from the navigation tabs at the top.
4. Within the Run SQL Query box add this query and click go to execute it:

Disable Comment Option:
UPDATE posts p SET comment_status = ‘closed’, ping_status = ‘closed’ WHERE comment_status = ‘open’;

Enable Comment Option:
UPDATE posts p SET comment_status = ‘open’, ping_status = ‘open’ WHERE comment_status = ‘closed’;

That’s it!

Thanks,

Shane G.

Popularity: 5%