Update Multiple Records with Array of Values
Posted on 2010-11-28
I found the update query structure on another post, and wanted to confirm this syntax will work. I am expecting to only update the field DESCR for 3 records in the example given. Does this look ok?
SET DESCR =
WHEN '1000029707' THEN 'APPLES CUYAMA'
WHEN '1000007698' THEN 'APPLES GINGR GOLD ORGANIC'
WHEN '1000007701' THEN 'APPLES GRNNY SMITH ORG'
WHERE ITEM_NO IN ( '1000029707' , '1000007698' , '1000007701')