removing domains from emails/logins

[David Miller]

On 11/10/2003 10:18 AM -0500, Jeremy L. Mordkoff wrote:

> Right now everyone's login ends with '@tatarasystems.com'. I would like
> to remove that everwhere. I know I have to fix the profiles table and
> change the preference to allow anything for a name. Do I need to do
> anything else? Anyone know how to craft a sql query to remove the domain
> from a field?

UPDATE profiles SET login_name = REPLACE(login_name,'@tatarasystems.com','');

-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/