How to fix emails containing double dot in domain?

Question

How do I update an email containing a double dot in its domain using raw mysql query?

So I have these emails having this format sample_email@gmail..com and turn it to this sample_email@gmail.com

Answer 1

replace should do the trick:

UPDATE mytable
SET    email = REPLACE(email, '..', '.')
WHERE  email LIKE '%..%'