update multiple column in single query

Question

I have list of the column in single table which I want to update to some else.

Table name:HyundaiRaw_New_april

Original: 
HART 2008-A
HART 2009-A
HART 2010-A
HART 2010-B
HART 2011-A
HART 2011-B
HART 2011-C
HART 2012-A
HART 2012-B
HART 2012-C
HART 2013-A

I want the above thing to be updated as 'ABC 2008-A'. I want HART to be replaced with "ABC" I tried updating using the below query

update HyundaiRaw_New_april
set deal='HART 2009-A','HART 2010-A','HART 2010-B'
where DEAL='ABC 2009-A','ABC 2010-A','ABC 2010-B'

and

update HyundaiRaw_New_april
set deal=HART 2009-A,HART 2010-A,HART 2010-B
where DEAL=ABC 2009-A,ABC 2010-A,ABC 2010-B

it does not work

set deal='HART 2009-A','HART 2010-A','HART 2010-B' is invalid SQL — user330315
– user330315, Commented Apr 3, 2014 at 11:16

TechDo · Accepted Answer · 2014-04-03 11:12:24Z

1

Please try:

update 
  HyundaiRaw_New_april
set DEAL=REPLACE(DEAL, 'HART', 'ABC')

answered Apr 3, 2014 at 11:12

TechDo

18.7k3 gold badges55 silver badges64 bronze badges

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

1 Comment

user3069018 Over a year ago

Sorry, the above query worked... how do you do when..its is all random alphabet, in this case it was "HART", how do you do?

Naveenkumar · Accepted Answer · 2014-04-03 11:17:01Z

0

It should work for you...

UPDATE TABLENAME
SET COLUMNNAME = REPLACE(COLUMNNAME,'oldValue','newValue');

answered Apr 3, 2014 at 11:17

Naveenkumar

4736 silver badges20 bronze badges

Comments

M.Ali · Accepted Answer · 2014-04-03 11:18:01Z

0

update HyundaiRaw_New_april
SET DEAL =  CASE WHEN DEAL = 'ABC 2009-A' THEN 'HART 2009-A'
                 WHEN DEAL = 'ABC 2010-A' THEN 'HART 2010-A'
                 WHEN DEAL = 'ABC 2010-B' THEN 'HART 2010-B'
            END

You also add a default value using ELSE clause in your CASE statement when no condition is met the column will be updated to default value mentioned in ELSE clause.

answered Apr 3, 2014 at 11:18

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

Collectives™ on Stack Overflow

update multiple column in single query

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related