Am 31.05.2011 03:40, schrieb zamri: > Hi all, > > 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 :-) _____________ REPLACE(str,from_str,to_str) Returns the string str with all occurrences of the string from_str replaced by the string to_str. REPLACE() performs a case-sensitive match when searching for from_str. mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww'); -> 'WwWwWw.mysql.com'
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
