Cacher is the code snippet organizer for pro developers

SELECT ID, display_name FROM wp_users;

UPDATE wp_posts SET post_author=<destino> WHERE post_author=<origen>;