The mailing list for listmasters using Sympa

[Rudolf Weeber <address@concealed>]

Hi,
On Sat, Dec 04, 2004 at 08:48:01AM +0000, Nick Holden wrote:
> Hi all,
> 
> I've just been contacted by a subscriber to one of my lists who says
> that their IPS (onetel.net.uk) have changed over all their email
> customers to new addresses - same user name but at onetel.com instead.
[...]
> Aside from complaining to Onetel about this very abrupt denial of
> service to their customers, I need a way to alter the sympa database
> table to search for one mail domain and replace with another without
> changing the local part of the email addresses - i.e. a bulk select and
> replace.
> 
> Has anyone written such a script? Or is there an easy way to do this in
> MySQL that I don't know about?
We had the saem problem at the university. A friend of mine sent me the
following sql-statement. I didn't try it, su use it on your own risk :-)

UPDATE <NameOfTheTable> SET email=REPLACE(email, '@studbox.uni-stuttgart.de',
'@stud.uni-stuttgart.de');



And do backup your database first :-)

Yours, Rudolf