an IF command in sql?

[xdentan]

What would be the easiest way to this in sql:

I need to subtract 100 from column foo, but if doing this makes the value of foo less than 0, then I need it to add 1 to column bar. Is there an IF command that would allow me to do this, or would i have to compare and subtract the values for each row individually?

thanks

[thorpe]

not at all tested.

UPDATE tbl
  CASE tbl.foo > 100 THEN
    SET tbl.foo = tbl.foo - 100
  ELSE
    SET tbl.foo = tbl.foo - 100, tbl.bar = tbl.bar + 1

[Lars_Berg]

update t
set bar = case when foo - 100 < 0 then bar + 1 else bar end,
     foo = foo - 100