Category: WordPress

Change WordPress displayed author name for all comments

November 6th, 2008 | No Comments | Print

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’

Recommended Reading

Like this article?

Subscribe to the  RSS feed, or to  daily email updates, right now!

Share and enjoy:  Digg  del.icio.us  TwitThis  Facebook

Leave a Reply

« How to create a WordPress theme option page
Wordpress 2.7-beta3 »