How do I change a user e-mail address?

[kencl]

Hi,

I'm an end user of eSupport. How do I change my e-mail address? There seems to be no facility in the system to do it, but I can have my host company throw an SQL statement against the DB.

I'm sure it's as easy as:

UPDATE user_account_tablename
SET email_fieldname = "new_email_address"
WHERE email_fieldname = "current_email_address"

All I need you to tell me is user_account_tablename and email_fieldname for the query above. Thanks.

[supportskins]

You can only change the email address from the Staff CP. You need to contact the helpdesk administrator to do that for you.