WordPress Help

Remove WordPress comments from a specific user

You can remove all comments left by a single user by deleting them in bulk in the WordPress database.

Warning: Always make a backup of your site before making any changes to the database.
  1. Sign in to phpMyAdmin.
  2. In phpMyAdmin, on the left menu, select the name of the database your site uses.
    select a database in phpMyAdmin
  3. On the top menu, select SQL.
    SQL tab in phpMyAdmin
  4. In the box below, enter the following code:
    DELETE from wp_comments WHERE comment_author_email = 'email address'
  5. In the code, replace email address with an actual email address associated with the comments you want to remove. For example, if comments are associated with jane@coolexample.com, the code would be:
    DELETE from wp_comments WHERE comment_author_email = 'jane@coolexample.com'
  6. (Optional) If your table prefix isn't wp_, replace wp_ before comments with your actual table prefix. You can check which prefix your site uses in the wp-config.php file.
  7. Select Go.
  8. When asked if you really want to execute the command, select OK.
    prompt in the wordpress database

All comments from the specified user are now removed from your site.

More info

Share this article