Easy way to change author from posts in WordPress

If you have to change author from lots of posts on WordPress, you can use SQL to save your time:

[sql]UPDATE wp_posts p SET p.post_author = 1 WHERE p.post_author <> 1;[/sql]

Remember! Be careful when you are querying on your database, do a backup before.