![](https://secure.gravatar.com/avatar/0fb12e7e19f0fd6be81a693450a1ca12.jpg?s=120&d=mm&r=g)
17 Oct
2014
17 Oct
'14
9:45 a.m.
CASE/WHEN syntax would be useful for UPDATE/SET clauses. Example:
UPDATE tbl1 SET col1 = CASE WHEN ... THEN ... ELSE ... END ;
I am not sure if this is conform to ANSI SQL. I would find it useful. Today I have to write multiple UPDATE queries with different WHERE conditions.