Search and replace bad domains in email list sql

Search_Replace_Emails.sql

update wp_mailster_subscribers set email = replace(email, '.comm', '.com');
update wp_mailster_subscribers set email = replace(email, '.combr', '.com.br');
update wp_mailster_subscribers set email = replace(email, 'gmail.com.br', 'gmail.com');
update wp_mailster_subscribers set email = replace(email, 'gamil.com', 'gmail.com');
update wp_mailster_subscribers set email = replace(email, 'hotmal.com', 'hotmail.com');
update wp_mailster_subscribers set email = replace(email, 'homail.com', 'hotmail.com');