updating multiple non sequential records

[robojob]

can anyone help me with a way to update a set of records that could potentially be non sequential...

[marek_mar]

You could try and use the IN() function.

UPDATE table SET field = 'value' WHERE primary_key IN(1, 32, 345, 3, 4);