Skip to main content
Keep your business open during COVID-19Learn More
Call us
Phone numbers and hours
Help Center

Explore our online help resources

We are experiencing high volume today, and as a result, you may experience longer than usual wait times.

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, the code would be:
    DELETE from wp_comments WHERE comment_author_email = ''
  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