[SOLVED] IN clause not working as expected

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
impulse()
Forum Regular
Posts: 748
Joined: Wed Aug 09, 2006 8:36 am
Location: Staffordshire, UK
Contact:

[SOLVED] IN clause not working as expected

Post by impulse() »

Can anybody see why the following query is only updating the first row inside the IN clause:

Code: Select all

UPDATE table
SET column = '999'
WHERE product IN ('a', 'b', 'c')
I'm having a clueless day today where errors don't make sense.
Last edited by impulse() on Thu May 17, 2007 7:06 am, edited 1 time in total.
impulse()
Forum Regular
Posts: 748
Joined: Wed Aug 09, 2006 8:36 am
Location: Staffordshire, UK
Contact:

Post by impulse() »

Dam Microsoft SQL server. They have to be arkward :)
Post Reply