help with editing commenter’s email

  • I noticed I mispelled my email address on some of my posts in my blog. I was off by 1 letter. Oops

    Anyone know the SQL querey to find and replace a user’s email address for comments? There’s 147 instances that I find and replacing it be hand would suck.

    Thx

Viewing 1 replies (of 1 total)

  • Try this.

    Replace wp_comments with the name of your comment table.

    UPDATE wp_comments SET comment_author_email = 'correct@address' WHERE comment_author_email = LCASE('bad@address');

Viewing 1 replies (of 1 total)
  • The topic ‘help with editing commenter’s email’ is closed to new replies.

Tags