How to transfer posts to another author

  • Resolved carla

    (@carla)


    18 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?

    Thanks!

Viewing 1 replies (of 1 total)
  • Pizdin Dim

    (@pizdin_dim)

    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.

Viewing 1 replies (of 1 total)
  • The topic ‘How to transfer posts to another author’ is closed to new replies.