PvSiKGGN

1# to get email account
2SELECT left(email, instr(email, '@') - 1);
3# to get email domain
4SELECT right(email, length(email) - instr(email, '@'));
5
6
7update user_user
8set email = replace(email, left(email, instr(email, '@') - 1), concat('XXXXX+user_', id))
9where email not like '%XXXXX%';
10
11update user_user
12set email = replace(email, right(email, length(email) - instr(email, '@')), 'gmail.com')
13where email not like 'XXXXX%';