change test
I applied both lines and tested in sequence.
I had modified 3 items to see the effect, however, in both cases it only picked up the last item in the list.
both produced the same result as before:
UPDATE `items` SET `ItemOrder` = 998 WHERE `ItemID`=27