Title: Changing post attribution
Last modified: August 18, 2016

---

# Changing post attribution

 *  [laurie](https://wordpress.org/support/users/laurie/)
 * (@laurie)
 * [21 years, 4 months ago](https://wordpress.org/support/topic/changing-post-attribution/)
 * Is there any way in WP to change a post’s attribution? I’ve been accidentally
   posting as ‘admin’ instead of using my regular user account. I’d like to reset
   the attribution of each article posted by ‘admin’ to show as posted by my regular
   user, and any drafts the admin user has too.
 * If that’s not something I can do through WP directly, is there a safe SQL query
   I can use to accomplish the same thing?

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [laurie](https://wordpress.org/support/users/laurie/)
 * (@laurie)
 * [21 years, 4 months ago](https://wordpress.org/support/topic/changing-post-attribution/#post-139611)
 * After a quick bit of digging in the DB I came up with the following SQL:
 *  update wp_posts set poster=2 where poster=1;
 * The question is, is that safe or does it potentially result in an inconsistent
   database?
 *  Thread Starter [laurie](https://wordpress.org/support/users/laurie/)
 * (@laurie)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/changing-post-attribution/#post-140060)
 * Well, I never did get any response on this one, so I’m going to go ahead and 
   take the plunge, having just backed everything up and upgraded anyway. Fingers
   crossed this doesn’t blow up in my face…
 *  [Cypher](https://wordpress.org/support/users/cypher/)
 * (@cypher)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/changing-post-attribution/#post-140061)
 * Doing just that SQL line should work without any problems.
 * Regards

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Changing post attribution’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Cypher](https://wordpress.org/support/users/cypher/)
 * Last activity: [21 years, 2 months ago](https://wordpress.org/support/topic/changing-post-attribution/#post-140061)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics