|  Home
Help

WordPress Help

Remove all WordPress comments before a specific date

You can remove all WordPress comments submitted by your users before a specified date.

  1. Log into phpMyAdmin (cPanel / Plesk / Web Hosting / Managed WordPress).
  2. Select the database for your WordPress site in the left-hand column.
  3. Click the SQL tab.
  4. Enter the following command into the "Run SQL query..." box:
    DELETE from wp_comments WHERE comment_date <= 'YYYY-MM-DD HH:mm:ss'

    Update the command for your situation as follows:

    • YYYY is year
    • MM is month number
    • DD is the day
    • HH is the hour
    • mm is the minute
    • ss is the seconds

      If you do not want to specify the time you can enter 00:00:00 for that part of the command.

    Warning: If your WordPress database uses custom table prefixes, then you must replace wp_ in each command with the prefix listed in your wp-config.php file.
  5. Click Go.

More info


Was This Article Helpful?
Thanks for your feedback. To speak with a customer service representative, please use the support phone number or chat option above.
Glad we helped! Anything more we can do for you?
Sorry about that. Tell us what was confusing or why the solution didn’t solve your problem.