Transfer posts to another account with a query?

[Leah]

I'd like to split my account, so that all posts are connected to a new account and I can save the original one for adminposts only. (Yes I'd like to keep the userid=1 for adminstuff).

I have changed userid for one post through the database and wondered if there is possible to do this for all posts with a query. (And then I could just change the adminposts back to userid=1 manually.)

Could this be done?
Should it?
Will it mess up the database?

[Leah]

Is this one ok if i adjust it?

http://www.vbulletin.com/forum/showp...75&postcount=4