MULTIPLE REPLACE IN ONE QUERY

Question

I have some car model and I want them to replace with other random number.

KMAL
UT
NC
WI
KMMA
KMKS
MA
MI
KMNJ
KMAR
TN
NH
AK
OK
KMWA
KMNY
KMMI
KY

I want these to be replaced with some other random name. I can either run the below query each time to replace, but it is time consuming.

update 
  table
set column=REPLACE(column, 'KMAL', 'LAMK')

Any other way I can do it in one go.

http://stackoverflow.com/questions/4830191/t-sql-using-a-case-in-an-update-statement-to-update-certain-columns-depending-o — ray, Apr 10 '14 at 09:52

score 1 · Answer 1 · answered Apr 10 '14 at 11:01

1

You could nest the replace function

update table set column=REPLACE(REPLACE(column, 'KMAR', 'RAMK'), 'KMAL', 'LAMK')

answered Apr 10 '14 at 11:01

Rohit Chaudhari

1 Answers1