Multiple update statements

[Jonob]

I have a query as follows:

UPDATE customer
SET account_id = account_id + 1
WHERE code = 1800

 

However, what I would like to do is update multiple lines, each with different criteria; something like:

UPDATE customer
SET account_id = account_id + 1 WHERE code = 1800
SET account_id = account_id + 2 WHERE code = 2000
SET account_id = account_id + 3 WHERE code = 2400

 

But this obviously wont work.

 

Any ideas on the most efficient way to write this would be appreciated.

[premiso]

UPDATE customer
SET (account_id = account_id + 1 WHERE code = 1800),
(account_id = account_id + 2 WHERE code = 2000),
(account_id = account_id + 3 WHERE code = 2400)

 

Give that a shot.