• Home
  • Sql
  • Assign posts to another author in WordPress

Assign posts to another author in WordPress

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