update y case

Good morning.

I am try a update more case this is my example:

update table1
set f1=(CASE f1
WHEN f1 '24' then '0'
WHEN f1 '25' then '1'
END)

But is no is ok.

Someone can help me.

Thanks.

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file