sql server - update sql for part of the result

Question

I have a table value like blow

id     value
 1    Default - Jimmy
 2    Market Return - Jimmy
 3    Sales Return - Jimmy
 11    Default - dfd
 21    Market Return - dfd
 31    Sales Return - dfd

now i need to update Jimmy to Kanan in all 1,2,3 id . and dfd with Jimmy

How can i do it?

Answer 1

You can use normal update with Replace as follows:

update your_table
set value = replace(replace(value,'jimmy','kanan'),'dfd','jimmy')