Support » Fixing WordPress » How to transfer posts to another author
9 years, 11 months ago
Because of imports, my posts are listed under two authors–both me. I remember seeing a plugin that allowed transfer of posts from one author to another, but I’m not finding it.
I don’t know about plugins but this SQL update will work in your favourite MySQL client:
update wp_posts set post_author=NEWID where post_author=OLDID;
where OLDID is your old user-id and NEWID is the new one.