How to re-assign all posts by UserA to UserB?

  • Hi everyone,

    I have a user, the main administrator, who has created 100+ posts. But I’d like to re-assign attribution of all those posts to another administrator, UserB.

    How can I do this in batch?

    Thank you!

Viewing 1 replies (of 1 total)

  • You can run a batch SQL command if you have PhpMyAdmin access.

    You first need the USERID of both the “old” author and the “new” author.

    Then, go to your PhpMyAdmin, and enter this as a SQL command:

    UPDATE wp_posts SET post_author=NEW_AUTHOR_ID WHERE post_author=OLD_AUTHOR_ID;

    Make sure to change “NEW_AUTHOR_ID” and “OLD_AUTHOR_ID” to your numerical values.

Viewing 1 replies (of 1 total)
  • The topic ‘How to re-assign all posts by UserA to UserB?’ is closed to new replies.