Title: batch editing comments (via sql?)
Last modified: August 18, 2016

---

# batch editing comments (via sql?)

 *  [cookiedude](https://wordpress.org/support/users/cookiedude/)
 * (@cookiedude)
 * [21 years, 3 months ago](https://wordpress.org/support/topic/batch-editing-comments-via-sql/)
 * Before I switched to WordPress, I used Greymatter for my blog. When I imported
   my old posts from Greymatter into WordPress, WP had trouble with a special character
   in my name (André) so it always looked like this: Andr?
    I found a way to fix
   this via an SQL instruction, but the problem still remains for all the time I
   replied to comments. I think a simple SQL instruction along the lines of “check
   comment_author, and when it’s Andr? change it to André” should solve this, but
   I don’t know anything about MySQL really. Is this possible? If so, what’s the
   instruction? TIA for your help folks!

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Kafkaesqui](https://wordpress.org/support/users/kafkaesqui/)
 * (@kafkaesqui)
 * [21 years, 3 months ago](https://wordpress.org/support/topic/batch-editing-comments-via-sql/#post-160625)
 * With a name like Kafkaesqu&#237, let’s just say I’m aware of the problem:
 * UPDATE wp_comments SET comment_author = ‘André’ WHERE comment_author = ‘Andr’;
 * If there’s an issue doing it this way, you can also reset based on your email
   address (which is what I do):
 * UPDATE wp_comments SET comment_author = ‘André’ WHERE comment_author_email = ‘
   ME@MY.SITE’;
 * Just change [ME@MY.SITE](https://wordpress.org/support/topic/batch-editing-comments-via-sql/ME@MY.SITE?output_format=md)
   to the email address you use in comments.
 *  [Kafkaesqui](https://wordpress.org/support/users/kafkaesqui/)
 * (@kafkaesqui)
 * [21 years, 3 months ago](https://wordpress.org/support/topic/batch-editing-comments-via-sql/#post-160626)
 * Er, name was meant to be Kafkaesquí — return the edit feature please!
 *  Thread Starter [cookiedude](https://wordpress.org/support/users/cookiedude/)
 * (@cookiedude)
 * [21 years, 3 months ago](https://wordpress.org/support/topic/batch-editing-comments-via-sql/#post-160862)
 * heh, thanks. I eventually got there by playing around with phpMyAdmin for a while–
   and found some comments that were labelled spam even though they weren’t in the
   process 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘batch editing comments (via sql?)’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [cookiedude](https://wordpress.org/support/users/cookiedude/)
 * Last activity: [21 years, 3 months ago](https://wordpress.org/support/topic/batch-editing-comments-via-sql/#post-160862)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics