[resolved] How to transfer posts to another author (2 posts)

  1. carla
    Posted 9 years 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.
    Any tips?


  2. Pizdin Dim
    Posted 9 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic