[resolved] Easily change author for all posts and pages? (4 posts)

  1. vavroom
    Posted 10 years ago #

    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?

  2. vavroom
    Posted 10 years ago #

    Never mind, I did it in phpmyadmin. Simple update query.

  3. syncbox
    Posted 10 years ago #

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


  4. vavroom
    Posted 10 years ago #

    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 :)

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.