Title: change wp_comments database  directly
Last modified: August 19, 2016

---

# change wp_comments database directly

 *  [dendixon](https://wordpress.org/support/users/dendixon/)
 * (@dendixon)
 * [18 years, 4 months ago](https://wordpress.org/support/topic/change-wp_comments-database-directly/)
 * I want to accept a spam comment and then delete it, rather than marking it as
   spam in the moderation queue.
 * My problem is once I do this, this particular comment author will now be able
   to make comments without going through the moderation queue. (My comments option
   is set to old comment authors are ok to post comments)
 * My solution is to edit the database in PhpAdmin – table “wp_comments” directly
   and change the setting from approved to spam.
 * Is this ok to mess with the database directly or is there a better method?
 * The reason I’m doing this is because of a bug in the “DG Review Site Plug In”
   which records a rating even in the moderation queue, but doesn’t change it back
   to the original ratings unless the comment is accepted first.
 * Thanks for any help/advice.

The topic ‘change wp_comments database directly’ is closed to new replies.

## Tags

 * [wp_comments](https://wordpress.org/support/topic-tag/wp_comments/)

 * 0 replies
 * 1 participant
 * Last reply from: [dendixon](https://wordpress.org/support/users/dendixon/)
 * Last activity: [18 years, 4 months ago](https://wordpress.org/support/topic/change-wp_comments-database-directly/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics