Mysql Update Scripts to change values [duplicate]

Question

I have table with values like

Book ID    email1               email2
101        [email protected]     [email protected]
102        [email protected]     [email protected]
105        [email protected]     [email protected]

I want to update all the values of email1 and email2 from test.com to testmail.com

e.g [email protected]  to [email protected],
and  [email protected]   to   [email protected]

how to write update query for this in mysql

Can you show what you have tried please.

P.Salmon
– P.Salmon

2019-09-12 09:53:11 +00:00
Commented Sep 12, 2019 at 9:53 — P.Salmon
– P.Salmon, Commented Sep 12, 2019 at 9:53

Nick · Accepted Answer · 2019-09-14 06:09:29Z

0

UPDATE table_name 
SET email1 = REPLACE(email1,'@test.com ','@testemail.com '), 
    email2 = REPLACE(email2,'@test.com ','@testemail.com ')

edited Sep 14, 2019 at 6:09

Nick

147k23 gold badges67 silver badges106 bronze badges

answered Sep 12, 2019 at 9:59

Mohamed CHIBANI

1561 gold badge1 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

Mysql Update Scripts to change values [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related