How to Manage WordPress Comments

Web Hosting in Pakistan

This article describes how to manage WordPress comments using the administration interface, as well as how to use phpMyAdmin to delete bulk amounts of comments (such as spam comments).


MANAGING COMMENTS USING THE WORDPRESS ADMINISTRATION INTERFACE

The most common way to manage WordPress comments is to use the administration interface. To do this, follow these steps:

  1. Log in to WordPress as the administrator.
  2. Under Dashboard, click Comments. WordPress displays all of the comments for all of your posts.

    If you have a lot of comments, it may help to filter the comments list. To do this:
    • Click Pending to only view comments awaiting review.
    • Click Approved to only view comments you have already approved.
    • Click Spam to only view comments you have marked as spam.
    • Click Trash to only view comments you have marked for deletion.
  3. When your mouse pointer hovers over a comment entry, the following options appear:
    • Approve: When you select this option, the comment is viewable by the public.


      Note: You can revoke approval by selecting Unapprove, and the comment will no longer be viewable by the public.



    • Reply: When you select this option, you can compose and publish a response to a comment.
    • Quick Edit: When you select this option, you can make quick changes to a comment's content using a basic editor.
    • Edit: When you select this option, you can make detailed changes to a comment's content.
    • Spam: When you select this option, the comment is marked as spam and does not appear on your site.
    • Trash: When you select this option, the comment is marked as trash and does not appear on your site.


DELETING COMMENTS USING PHPMYADMIN

There may be times when it is easier to delete WordPress comments directly in the MySQL database by using phpMyAdmin. For example, if a post has been spammed with hundreds of comments, it is often easier to do a bulk delete operation in phyMyAdmin.

Note: If you are receiving a lot of spam comments, you should consider adding CAPTCHA protection to your WordPress site. CAPTCHAs can help reduce the amount of spam comments on your site significantly.

 

To delete comments using phpMyAdmin, follow these steps:

  1. Log in to cPanel.
  2. In the Databases section of the cPanel home screen, click phpMyAdmin.
  3. In the left-hand pane of phpMyAdmin, click the WordPress database. A list of tables in the database appears.
    • Typically, the WordPress database is username_wpXXX, where username represents your cPanel username, and XXX is a three-digit number.
  4. Click the wp_comments table.
  5. Each post has its own post ID, so to group comments by their parent post, click the comment_post_ID heading.
  6. To delete a single comment, click Delete in the comment's row, and then click OK to confirm the deletion:

    Deleting Spam WordPress Comments using PHPmyAdmin

  7. To delete multiple comments, select the check boxes for the comments you want to delete, and then click Delete in the With selected section:

    Deleting Spam WordPress Comments in Bulk using PHPmyAdmin

  8. Click Yes to confirm the action.

Was this answer helpful?

 Print this Article

Also Read

How to use Google Analytics with WordPress

This article discusses several ways you can use Google Analytics with a WordPress site. USING...

How to clear the cache in WordPress

WordPress does not have a built-in caching mechanism. However, many people use a caching plugin...

How to Determine the WordPress Version

This article describes how to determine the version of a WordPress installation. USING THE...

How to debug WordPress

This article describes several settings you can use to help debug WordPress.DEBUGGING WORDPRESS...

How to update WordPress database configuration settings

This article describes how to update database configuration settings in WordPress. You may need...

Web Hosting in Pakistan

Powered by WHMCompleteSolution