Change all email addresses by SQL query? - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » General Assistance (How Do I?) » Change all email addresses by SQL query?

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

Top Posters (30 Days)

Ruben	49
DennyP	24
Gizmo	23
Dunny	18
SteveS	14
AllenAyres	12
dbremer	10
drkknght00	9
SD	9
driv	8

Latest Photos

Basildon Town Centre looking from the rounderbout

Topic Options

#181879 - 04/01/07 09:09 PM

Change all email addresses by SQL query?

ThreadsUser Offline

member

Registered: 11/22/06
Posts: 163

Is it possible to perform an SQL query to change all member email addresses to the same email address to save me doing this individually? I would like to change all publicly displayed and real email addresses to samename@company.com

Thankyou.

Top

Express Hosting

Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."

#181883 - 04/01/07 09:37 PM

Re: Change all email addresses by SQL query? [Re: ThreadsUser]

Gizmo

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA

I don't really see why you'd want to do this, but a simple mysql query:

Code:

UPDATE `ubbt_USER_PROFILE` SET `USER_DISPLAY_EMAIL` = 'user@domain.com';

Just execute via the sql command section of your control panel.

_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!

Top