PHP MYSQL UPDATE WHERE multiple conditions

Question

I was wondering if you can do an Update with multiple conditions like so:

UPDATE participantes SET confirmado = 1 WHERE id = 19 AND id = 20 AND id = 21;

participantes -> Table

confirmado -> field of the table participantes.

In that case, no - you'd need id to be three different values. You can try WHERE id IN (19,20,21) to update multiple rows; or WHERE cond1=19 AND cond2=20 for checking different fields. — andrewsi
– andrewsi, Commented Apr 30, 2014 at 17:07

Aaron · Accepted Answer · 2014-04-30 17:07:47Z

10

To accomplish what you're describing, I would, instead, use the IN clause:

UPDATE participantes SET confirmado = 1 WHERE id IN(19, 20, 21);

answered Apr 30, 2014 at 17:07

Aaron

5,2471 gold badge21 silver badges21 bronze badges

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

1 Comment

DWolf Over a year ago

Almost wrote this exactly, kudos

Noah · Accepted Answer · 2014-04-30 17:29:13Z

9

MySQL's AND clause will only work when ALL of the criteria are met. What you're looking for is OR. In the format that you provided:

UPDATE participantes SET confirmado = 1 WHERE id = 19 OR id = 20 OR id = 21;

Although, the above-noted IN (19, 20, 21) would be better for this specific use case.

Your original query was trying to look for a single row where id was simultaneously 19, 20, and 21, which would never happen.

answered Apr 30, 2014 at 17:29

Noah

1,88716 silver badges19 bronze badges

Comments

Stephen Rauch · Accepted Answer · 2018-10-11 03:26:37Z

0

How about this?

UPDATE participantes SET confirmado = 1 WHERE id >= 19 AND id != 50 AND id != 51;

edited Oct 11, 2018 at 3:26

Stephen Rauch♦

50.1k32 gold badges119 silver badges143 bronze badges

answered Oct 11, 2018 at 3:09

Ardi

1

1 Comment

Fatimaezzahra Rarhibou Over a year ago

I tried this (AND) multiple times and different query but it doesn't seem to work

Collectives™ on Stack Overflow

PHP MYSQL UPDATE WHERE multiple conditions

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related