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)

  • 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 = ‘[email protected]’;

    Just change [email protected] to the email address you use in comments.

    Er, name was meant to be Kafkaesquí — return the edit feature please!

    Thread Starter cookiedude

    (@cookiedude)

    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.