MySQL Query Needed to Delete Older Comments in Wordpress

[Another Blogger]

Hello everyone

I run a self-hosted WordPress blog which has approx. 2000 topics. Many of them contain more than 200 comments.

I want to have a MySQL query which first searches for posts which have more than a fixed number of comments such as 50 comments and then delete the extra old comments.

For example, the query searches for posts having more than 50 comments and then it deletes all old comments from those posts to make their comment count under 50.

I'll really appreciate if someone can provide such query statement.

Thanks in advance.

 

[Infopro]

You might do better to ask about this sort of thing over on wordpress.org

 

[Another Blogger]

^^ Thanks for your reply. I asked there already but didnt get a single reply in 4 days.

 

[Infopro]

Probably has been answered so many times no one cared to help you out.

/http://wordpress.stackexchange.com/questions/15870/how-to-delete-old-comments-by-date
/http://gerardmcgarry.com/blog/wordpress-deleting-comments-old-blog-entries


I googled: delete old comments on wordpress


GL!

 

[Another Blogger]

Sorry to say but I have already checked those topics. They came on first page while searching on Google. My question is different. I dont want to delete all older comments. I want to delete comments from only those topics which contains more than 50 comments. I want to keep latest 50 comments from each topic and delete all previous comments from those topics.

 

[JaredR.]

Instead of closing the thread, would you mind sharing the solution you found for the benefit of the community?

 

[Another Blogger]

^^ No one helped so I decided to manually delete comments from older topics using Wordpress Admin CP. It'll take time but thats the last option to do.