DiggingIntoWordPress

by Chris Coyier & Jeff Starr

Daily archives: Monday, August 9, 2010

Easy Comment Management via SQL

Posted by on

Here are some sweet SQL code snippets for easy comment management. Sometimes it’s easier to modify comment status and delete unwanted comments on a sitewide basis. Using a program like phpMyAdmin makes it so easy to do stuff like remove spam, close/open comments on old posts, enable/disable pingbacks for specific time periods, and so on. Just remember to backup your database before running any queries.

Code is poetry