You are here: Home / Sql / Assign posts to another author in Wordpress

Assign posts to another author in WordPress

August 30, 2012 by ·

First find the USER ID from wp_users table.

Execute the following SQL command from the Database:

UPDATE wp_posts SET post_author = '1' WHERE post_author = '10';[/code] 


switches the posts authored by user No 10, to ownership by user No 1
Filed Under: Sql Tagged With: ,

You are reading this post on Joel G Mathew’s tech blog. Joel's personal blog is the Eyrie, hosted here.