How to replace a string in a table

Question

i have a table like below

empid empname grade 
1      rr       A 
2      raju     B 
3      lokesh   A 
4      sathish  B

i want repalce the A by B and B by A in above table using single update statement can any one suggest a good answer in sql..

Which database you're working on?

Incognito
– Incognito

2014-01-23 05:01:16 +00:00
Commented Jan 23, 2014 at 5:01 — Incognito
– Incognito, Commented Jan 23, 2014 at 5:01

juergen d · Accepted Answer · 2014-01-23 05:13:24Z

2

update your_table
set grade = case when grade = 'A' then 'B'
                 when grade = 'B' then 'A'
            end
where grade in ('A','B')

answered Jan 23, 2014 at 5:13

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

1 Comment

juergen d Over a year ago

@Mr.Radical: Thanks for your concerns. But accepting an answer is totally up to the OP. Please don't ask users to accept something in the future.

Not a bug · Accepted Answer · 2014-01-23 05:18:33Z

0

Try this query

Update table
set grade = CASE  
               WHEN grade = 'A' THEN 'B' 
               WHEN grade = 'B' THEN 'A' 
            END 
     WHERE grade IN ('A', 'B')

edited Jan 23, 2014 at 5:18

answered Jan 23, 2014 at 5:02

Not a bug

4,3342 gold badges43 silver badges82 bronze badges

1 Comment

juergen d Over a year ago

This replaces only one case and not both at the same time as the OP wants.

Collectives™ on Stack Overflow

How to replace a string in a table

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related