How to Delete Old Comments by Date?

by

I run a contest/giveaway blog at www.mommylivingthelifeofriley.com and currently have over 160,000 comments on 1100 posts. I would like to find a way to delete all comments from my site which are older than 6 months, so as to improve my site’s overall performance. Does anyone have any ideas on how to accomplish this? Thanks for your help!

1 Answer
1

You could easily do this using mysql:

DELETE FROM wp_comments WHERE comment_date < DATE_ADD(CURDATE(), INTERVAL -6 MONTH)

Leave a Comment