Multiple row updates

[shaunthomson]

Gidday

Just wondering how, using one query, to update a counter column with + 1 in multiple rows when the row ids are supplied.

So:

UPDATE table
SET col=col+1
WHERE id in (1,2,3)

This doesn't work. It does work if the value of col is static. Is it possible, or will I have to create a separate query for each row update?

Thanks for your help.

[guelphdad]

what doesn't work about it?
It would increment the value of col by 1 for for each of id=1, id=2 and id=3.

[shaunthomson]

That's what I thought too, but it's not working. I going to go back over my code - I think something I've done is screwy.

[guelphdad]

So either
a) you haven't shown your actual query you are having trouble with
b) you've introduced a front end application code that we don't know about

Either or it is tougher for us to help you with the larger picture.

[abduraooft]

UPDATE table
SET col=col+1
WHERE id in (1,2,3)

What's the actual name of that table?
The name table is a mysql keyword. You shouldn't name your table by that word.

[shaunthomson]

Thanks guys

I had an error elsewhere in my code. Plus, your comments have be taken in.

Cheers