How to Delete Old Comments by Date?

You could easily do this using mysql:

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

Related Posts:

  1. SQL query to delete comments older than 90 days?
  2. Resetting comment count
  3. Would switching to InnoDB from MyISAM improve performance of comments table?
  4. human_time_diff() returns “48 years ago” for all comments
  5. Get last seen date/time in wordpress get_comments() [closed]
  6. Recent comments from my blogs only
  7. Changing “submitted on date” of comments
  8. Log file reports SQL Error processing child comments
  9. Delete all one-word comments
  10. Control panel loads slowly due to 2 slow queries on comment table
  11. Placed on + only date (not time)
  12. How to amend time format of comments, using child-theme?
  13. comment_date() & comment_time() not working from functions.php
  14. How do I comment out a block of tags in XML?
  15. R: Comment out block of code
  16. Why do I get comment spam even with Akismet and Captcha?
  17. What tools are available for managing/writing to WordPress? [closed]
  18. How to rearrange fields in comment_form()
  19. setting comments off as default for pages and custom post types?
  20. Is it possible to pull comments from facebook into your blog?
  21. Filtering the Admin Comments List to Show Only Comments from the Current User?
  22. Non-threaded comment replies with link to original comment
  23. Approve comment hook?
  24. Commenting in user profile page?
  25. How to change “You must be logged in to post a comment.”
  26. comment_post_ID 0 (cannot remove from dashboard)
  27. Disable comments on all posts/pages
  28. How do I delete all comments from a specific old blog post?
  29. Removing the “Website” Field from Comments and Replies?
  30. Stop WordPress redirecting comment-page-1 to the post page?
  31. Importing old Disqus comments into WordPress
  32. How to add a class to the comment submit button?
  33. How to wrap submit button of comment form with div
  34. How to enable comments for pending and draft posts?
  35. Using WordPress’ WYSIWYG for comments
  36. Enable Submit Comment Without Page Reload (Using Ajax)?
  37. What for is the table “wp_commentmeta” exactly?
  38. Getting Post Comments for post ID using WP_Query() and a Custom Loop?
  39. Add option to disable comments on a per posts basis?
  40. When importing – failed to import: Invalid post type feedback
  41. How to change the email notification recipient (user) for new comments?
  42. Redirect user to a custom url after submitting the comment
  43. Paginate result set from $wpdb->get_results()
  44. Change Comment Author Display Name
  45. Custom comment type based on thread level
  46. How to add internal, revision comments to page updates
  47. How to load and show comments with AJAX instead of pagination?
  48. Linking to Page Showing Only Comments Without Parent Post
  49. Comment Reply javascript
  50. How do we remove the H3 tag for the reply-title I.D
  51. Comments not appearing at all
  52. comments reply script not working
  53. How to display comment form error messages in the same page
  54. 3 moderators to approve comment
  55. How to deal with small scale comment spam on small commercial sites? [closed]
  56. What should I do to make generated avatars different for anonymous comments?
  57. A plugin where users can comment with Facebook or Twitter or OpenID [closed]
  58. Check If comment author is registered
  59. Comments screen in backend, how to disable email address of commenter for non admins
  60. Add comments from the admin panel?
  61. How can I limit the number of comments per registered user per day?
  62. One comment per user per post but be able to reply to existing comments
  63. How to use a custom comments template
  64. Comment visibility
  65. What’s the easiest way to close comments on media/attachments?
  66. Reverse comment pagination numbers
  67. Get comments for more than one post
  68. How can I add comments to a page?
  69. How to remove comment spam in WordPress
  70. Post Comments using WP REST API v2 in WordPress
  71. show number of open comments on custom dashboard
  72. Show content only if member left a comment
  73. Add placeholder attribute to comment form fields
  74. Why do I get accidental comments without (the required) email address?
  75. How is comment spam received without a comments form?
  76. Does a reply to a wordpress comment notify the author of the comment?
  77. What are the current recommended best-practices for comments.php?
  78. How do I set up real anonymous posting in bbpress forums? [closed]
  79. Comment Count for each Comment Author
  80. Link name in comments to Author page? Comment Author Meta in Comments?
  81. How do I turn off wordpress comments ability to capture a users ip address?
  82. Showing comments only to same custom user role
  83. Parent comment’s author name
  84. Success message in comment form
  85. get_comments_number of depth-1 (Level 1) (1 post)
  86. Show comments from multiple post IDs in comment template
  87. Running a function on comment status change
  88. How to allow the reply link to remain on the comment form after I have reached my 10 nested comment limit?
  89. How can I control the comment counts filtering my CPT replies?
  90. Hook to edit an column on comments screen?
  91. Allowing more elements in comments via functions.php
  92. Set post comments open function
  93. Comment Author Name In Reply Form
  94. How to auto-approve internal pingbacks?
  95. Deep customization of the comment form?
  96. Post comment as different user than logged in
  97. “Categories” for comments?
  98. get recent comments of a particular category
  99. Threaded comments – deleting parent comment leads to orphan comments
  100. How to hide “Trackback” on paginated comments

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)