Change WordPress displayed author name for all comments

Thursday, November 6th, 2008
Advertisement

Subscribe.
Enter your email:

Whenever you change the display name Users >> Your Profile >> Nickname, and set  the “Display name publicly as”, it will only affect the newly posted comment by you. Actually, you can change the displayed author name for all comments.

You can change the displayed name of comment author for all comments using this sql statement:

UPDATE `wp_comments` SET `comment_author`=‘old-name’
     WHERE `comment_author`=‘new-name’
If you are new here, you might want to subscribe to the RSS feed or newsletter.

Enter your email address:

Creates the exact copy of your hard disk and allows you to instantly restore the entire machine.
New Acronis True Image Home 2010 is the most reliable and easy in use backup solution. Now with online backup option!
15% Discount Code: FMAATIH2010

What else?

Like this article? Share it

 Digg  del.icio.us  TwitThis  Facebook  Reddit  StumbleUpon

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>