Friday, August 21, 2015

MySQL: Change Domain Name on email address (leave username) / mountainash - Snipt

 MySQL: Change Domain Name on email address (leave username) / mountainash - Snipt





update [TABLE] set [EMAIL] = replace([EMAIL], SUBSTRING_INDEX([EMAIL], '@', -1), '@XYZ.COM');

No comments:

Post a Comment