[SOLVED] updating the same column in multiple rows...

[lordvader]

Lets say I want to increment column "totals" in several different rows:

 

UPDATE mytable SET totals=totals+1 WHERE id=1 OR id=3 OR id=7 OR (dozens more...)

 

Is this the fastest syntax? Or is CASE WHEN THEN better? Or is there an even better way?

 

Thanks

 

By the way, I can't update every row's 'totals' column, only specific rows.

[fenway]

try id IN ( 1,3,7,etc.)

[lordvader]

Thanks