SQL update multiple rows based on multiple where conditions

Question

I have a Dossiers table with a print_flag column and i want set print_flag=1 for multiple rows.

UPDATE dossiers SET print_flag = 1 
WHERE id=1013997,id=1020799,id=1020800,id=1020800;

How should the SQL look like?

w3schools.com/sql/sql_and_or.asp

podiluska
– podiluska

2014-06-20 09:37:55 +00:00
Commented Jun 20, 2014 at 9:37 — podiluska
– podiluska, Commented Jun 20, 2014 at 9:37

NcDreamy · Accepted Answer · 2014-06-20 10:38:56Z

3

You should use the IN clause as it'll allow you to use multiple values for a single column.

UPDATE dossiers SET print_flag = 1 
WHERE id IN(1013997, 1020799, 1020800);

edited Jun 20, 2014 at 10:38

answered Jun 20, 2014 at 9:04

NcDreamy

8057 silver badges14 bronze badges

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

Comments

Deepshikha · Accepted Answer · 2014-06-20 09:05:00Z

1

You need IN clause as:

UPDATE dossiers 
SET print_flag = 1 
WHERE id IN (1013997,1020799,1020800,1020800);

answered Jun 20, 2014 at 9:05

Deepshikha

10.3k2 gold badges24 silver badges21 bronze badges

Comments

Raj · Accepted Answer · 2014-06-20 09:05:16Z

1

UPDATE dossiers 
SET print_flag = 1 
WHERE id IN(1013997,1020799,1020800,1020800);

answered Jun 20, 2014 at 9:05

Raj

10.9k2 gold badges47 silver badges53 bronze badges

Comments

g2server · Accepted Answer · 2014-06-20 09:35:16Z

1

Use the IN clause. (BTW, i dont think the double of 1020800 is necessary, so i've omitted it.)

   UPDATE dossiers SET print_flag = 1 
   WHERE id IN(1013997, 1020799, 1020800);

answered Jun 20, 2014 at 9:35

g2server

5,4173 gold badges31 silver badges42 bronze badges

Comments

Sumit Manchanda · Accepted Answer · 2014-06-20 09:14:44Z

0

If you are sure about the ids you are passing in the query are existed in table than you may try this one :

    UPDATE dossiers SET print_flag = 1 WHERE id IN (1013997,1020799,1020800,1020800);

edited Jun 20, 2014 at 9:14

answered Jun 20, 2014 at 9:07

Sumit Manchanda

1977 bronze badges

Collectives™ on Stack Overflow

SQL update multiple rows based on multiple where conditions

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related