[SOLVED] IN clause not working as expected
Posted: Thu May 17, 2007 5:52 am
Can anybody see why the following query is only updating the first row inside the IN clause:
I'm having a clueless day today where errors don't make sense.
Code: Select all
UPDATE table
SET column = '999'
WHERE product IN ('a', 'b', 'c')