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

[kh99]

I think this should work:

UPDATE user set email = CONCAT(username, '@officialdomain.com')

I tried it, but you might want to add "WHERE userid = X" (where X is one userid) at the end to test it for one user first. Also, it's always a good idea to make sure you have a database backup before doing stuff like this.


Oh, and hopefully everyone's username is a valid email username (and you don't allow spaces or unusual characters), or else you might have to do more processing on the username.

[flyguye]

Brilliant! Worked like a charm. Tested it using "WHERE userid = X" and it worked perfectly.

The only special characters in the usernames are "." ... hopefully that doesn't have any effect. Will do a mass change and let you know if it doesn't work!

Thanks again!