Change the Author of Multiple WordPress Posts

Disclaimer: This idea requires access to the shell on your webserver.

This is the SQL query you’ll use:

I had posts that were assigned to Admin (which by default is user ID 1), and I wanted to assign them all to my user (which in this case is user ID 2).

My query looked like this:

That will go through the posts database and update the author for all of them.


Leave a Reply

Your email address will not be published. Required fields are marked *

Copyright ยฉ 2024