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:
|
1
2
3
|
UPDATE wp_posts
SET post_author='[NEW ID]'
WHERE post_author='[EXISTING ID]';
|
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:
|
1
2
3
|
UPDATE wp_posts
SET post_author='2'
WHERE post_author='1';
|
That will go through the posts database and update the author for all of them.
—
Jon