MYSQL: Update multiple rows

[Tea_J]

Hi,

How do you update multiple specified rows in MYSQL ?

something like

DELETE FROM mytable WHERE id=1,id=2,id=3,id=50;

(of course, the above didnt work.)

i tried to use AND statements, but that didnt do anything.

Please advice you guys.. thanks

tea

[bad76]

Hi,
AND tell that is both true and none row can have id=1 AND id=2

You can try with OR...

[Tea_J]

darn.. why didnt i think of that.. hehe.. thanks mate

[bad76]

😃 can't think all 😃

see you