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. R: Comment out block of code
  15. How to rearrange fields in comment_form()
  16. Commenting in user profile page?
  17. How do I delete all comments from a specific old blog post?
  18. Removing the “Website” Field from Comments and Replies?
  19. How to load and show comments with AJAX instead of pagination?
  20. Comments not appearing at all
  21. get recent comments of a particular category
  22. Hook/Filter before and after comments
  23. Comment form validation
  24. Is it possible to move a comment that should be a reply to another comment?
  25. Can I seperate comments from post?
  26. I have tried using Plugins to remove 72K comments with no success
  27. How to refresh the page when an admin trashes a comment from Comments in the admin site?
  28. How to add a div on comment fields / edited
  29. How to move comments form above comments list in wordpress
  30. Remove “Comment” column in all post-types
  31. How stop the process of submitting a comment if a field is empty?
  32. Can WordPress store comment cookies on two different computers?
  33. How to get last comments but not from admin (or other specific user role/capability)?
  34. Edit Comments Form in TwentyEleven
  35. How can I automatically delete comments that contain chinese / russian signs?
  36. Send Notifications to All Admins
  37. Disable comments
  38. Community Moderation Plugin for Comments [closed]
  39. Allow contributors to moderate comments comments on posts they write
  40. Bots posting comments on pages
  41. default callback function in wp_list_comments
  42. Why are authors allowed to approve comments on their posts? How to revoke privilege?
  43. Why is comments_template() working without a comments.php file?
  44. Comments deactivated
  45. Turning off trackbacks & comments
  46. Display comments on homepage of twenty seventeen theme
  47. How to dynamic Heart Like in WordPress?
  48. Comment Moderation and CDN Caching
  49. Assign author to comment from post edit page
  50. The “\” is missing when comments is updated
  51. Using defer or async JavaScript attributes prevents pingbacks and trackbacks from being sent
  52. Why do I have to manually approve comments from one of my users who already has an approved comment?
  53. Posting comment returns 404
  54. How-To and Troubleshooting Canonical Links for Paginated Comments
  55. How to hide trackbacks on wp-admin/edit-comments.php
  56. Get comments only for certain specific users in template file
  57. Using a static callback on wp_insert_comment
  58. How to direct user after comment save
  59. Show comment pop up links as text only
  60. Displaying comments on pages distinguished by GET IDs
  61. Is there a hook to update / replace values in the “Enable threaded (nested) comments x levels deep” drop down?
  62. Update comment meta for all comments of specific post
  63. How to permanently delete pages I have already trashed?
  64. Additional content every x comments
  65. How to change comment texts that has a specific comment_ID – Hook into comment
  66. counting trackbacks, pingbacks and comments of a post
  67. Adding comments section to website integrated WordPress instance
  68. How to Define Custom Number of Items in Comment Feed
  69. How can i change the order of comments?
  70. Modify links in user comments
  71. How indicate when a functions was upgraded in relationship to the entire program [closed]
  72. Empty comments field or
  73. infinite loop on page with comments after changing comments.php and header.php
  74. What templates/funtions needed in custom theme to allow comments the new 3.0 way
  75. Default Gravatar not showing for pings
  76. How include comment and post count of user in this custom query
  77. How can I hide comment of the authors from their published posts?
  78. How to customize ‘children comments’ in WordPress?
  79. Disallow Comments
  80. Comment field override
  81. Keep comment author’s name on their comment even when their account is deleted
  82. &nbsp not working in comments
  83. WordPress Commenting System User access and Security
  84. Comments.php is not getting called on main blog page
  85. Allowing comments on author pages
  86. Comment section not appearing on posts
  87. How can I see whether a commenter has subscribed to be notified of replies / other comments to a post
  88. Where is the Leave a Comment link set
  89. Disable comment moderation in multisite
  90. URLs to user page is broken
  91. Comments Template shows, but not the comments
  92. Auto disable comments with custom field
  93. I want to fill the comment with the comment count?
  94. delete user not working
  95. How to remove or customize “Comment” in comments form?
  96. Getting thousands of spam comments
  97. Comments on pages not appearing, even though I enabled them
  98. check if a comment was made by a registered user
  99. TinyMCE in comment reply form showing toolbar but can’t edit reply
  100. Add pending for reply comment in console WordPress

Leave a Comment