How to replace a part of the string using mysql

Question

I have 100 email address in my mysql table and its look like [email protected], [email protected], [email protected], [email protected],[email protected], [email protected], ect.... I need to change all @xy.com to @xyz.com using mysql query.

Please help me for query

Thanks in advance!

You'll need to show some effort yourself. Just as a hint, you will be looking at using LIKE in the WHERE part. — Andrius
– Andrius, Commented Nov 9, 2015 at 9:34

Rahul Tripathi · Accepted Answer · 2015-11-09 09:37:49Z

3

You can try this:

update myTable
set email = replace(email, '@xy.com', '@xyz.com')
where email like '%@xy.com'

answered Nov 9, 2015 at 9:37

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1