SQL Query : Change all users' email address

[flyguye]

Hi,

I'm trying to change all users' personal email address (which they previously registered with) to their official email address. Each user is issued an official email address which corresponds to their username.

Example..

I NEED TO CHANGE THIS

username : john1
email : johnnytheman@personaladd.com

TO THIS:

username : john1
email : john1@officialdomain.com

Is there an SQL query for this? The new email address has to correspond with their registered username, as well as the new domain.

Any help with this is greatly appreciated. I can't rely on the users to change their emails themselves! :P

Using VBulletin 4.1.11 PL 1