User-583959464 posted
how can i add condition in where clause. can i use "case when" in the where clause to update record.
update table_name set col_1=99 where col_2=xx and col_3=yy and (case when col_4 = '01' then '02'
when "02" then "03" when "04" then "05")
that mean when col_4=01 then the condition is to retrieve record col_4="02" to update.
or other better way to do that. any example for me.