PTwWXn0n

1update wp_mailster_subscribers set email = replace(email, '.comm', '.com');
2update wp_mailster_subscribers set email = replace(email, '.combr', '.com.br');
3update wp_mailster_subscribers set email = replace(email, 'gmail.com.br', 'gmail.com');
4update wp_mailster_subscribers set email = replace(email, 'gamil.com', 'gmail.com');
5update wp_mailster_subscribers set email = replace(email, 'hotmal.com', 'hotmail.com');
6update wp_mailster_subscribers set email = replace(email, 'homail.com', 'hotmail.com');