Update part of data in column

Question

How would I change data in column Email, for example; all hotmail.com addresses need updating to outlook.com, but leaving all characters before @ ?

So [e-mail] will become [e-mail].

UPDATE * from Users
SET '[e-mail]'
Where Email LIKE '%hotmail.com';

Would this work?

Answer 1

No, it's not the right way to replace string. You should use Replace function.
Try this-

UPDATE *
SET Email = REPLACE(Email, 'hotmail.com', 'outlook.com')
WHERE Email like 'hotmail.com%'

Answer 2

That worked, thanks a lot :)