Support » Fixing WordPress » Easily change author for all posts and pages?

  • Resolved vavroom


    I can’t seem to find anything I search for last couple days 🙁

    I have about 125 posts and pages that I created under one author. I would like to change the other for all of them to someone else. I can obviously go one by one and manually do it, but I imagine there might be an easier way to do it. Any idea?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Never mind, I did it in phpmyadmin. Simple update query.

    Well, post the query you used… it would be helpful for others!


    heya syncbox, yeah, of course, I should have thought about it.

    WARNING: if you don’t know what you’re doing with phpmyadmin, be careful, you can *REALLY* mess up your site.

    The query I ran in the SQL tab was:

    UPDATE wp_posts SET wp_posts.post_author = “2” WHERE (((wp_posts.post_author)=”1″));

    the “2” is the ID of the new author, the “1” the ID of the current author.

    Have fun 🙂

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Easily change author for all posts and pages?’ is closed to new replies.