Online Free Tutorials Guruji Guide & Materials – Solved Questions Answers
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 [email protected] and turn it to this [email protected]
replace should do the trick:
SET email = REPLACE(email, '..', '.')
WHERE email LIKE '%..%'
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.