removing domains from emails/logins

MattyT matty at chariot.net.au
Sat Dec 13 10:10:50 UTC 2003


On Tue, 2003-11-11 at 06:00, David Miller wrote:

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

Another good reason for distinguishing login name from email address.

-- 
         Matthew Tuck: Software Developer & All-Round Nice Guy        
 My Short Autobiography: 1985 Grade Bin Monitor 1990 Class Clown Award
1992 Awarded Most Likely To Spontaneously Combust 1996 Crowned Galactic
         Emperor 1998 Released From Smith Psychiatric Hospital





More information about the developers mailing list