Re: case when... end in update clause?

>>
>>  I use one small Example, table: test
>>  =============================
>>  id
>>  ==
>>  5
>>  6
>>  8
>>
>>  try to update test.id
>>
>>
>>  update test
>>
>>  case
>>   when id =5 then SET id = 6
>>  end
>>  ;
> 
> would this work:
> 
> update test set id=5 where id=6;
> 

No. I provide one small fake example.


I want to know how to use case when in update/set clause as the following:

update test
set id = case when id = 5 then 6 else id end;


Thanks.