How to move all wordpress posts from old author to another user without deleting old member?

Most of us start to write posts by default admin user. Then  we may have more author. or maybe you have lots of posts under a author but now you wish to move them to another author without deleting the old author?  here is tips how you can do it.

You can do this with two way.

A) Moving post to new author by deleting old author:

at user section of  WordPress admin area, find old author and Delete old author. then WordPress will ask you who you want to assign the posts that was belong to old author. Pretty simple, but you will lose old author user.

If you like keep old author user but move all post of old author to new one. then try following solution:

B) Moving post to new author without deleting old author:

First we need find old author id. You find it by holding mouse on old author username at user section in WordPress admin area

You also can do it via phpmyadmin by using following sql

 SELECT ID  FROM wp_users where `display_name`='old_author_name'

same you can find ID of new author.

Now we move all post from old author to new author . here is the sql code

 UPDATE wp_posts SET `post_author`='new_auhtor_id' WHERE
`post_author`='old_author_id'

There are no plugin to do above. If you enjoined it tweet it!