On Tue, May 31, 2011 at 4:24 PM, Reindl Harald <[email protected]>wrote:
> > > Am 31.05.2011 10:21, schrieb zamri: > > > I have changed my domain. So I need to act fast to all these in one > go: > > > > > > 1. How do I add the new alias to all of my users? > > > 2. How do i delete old aliases to all my users? > > > > > > Any help appreciated. > > > > > http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_replace > > > > update dbmail_aliases set > alias=replace(alias,'@olddomain','@newdomain'); > > BUT try this query somewhere, i left the bed 5 minutes ago :-) > > > > Thanks a lot. This works > > cool, i can write queries while i am sleeping :-) > thats why i use dbmails > > > I bet you can also write queries while swimming... LOL . This solution should go into dbmail's wiki. Thanks again.
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
