sql update case null

間違い
update prof1 set k_number = case when k_number = null then 1 else k_number +1 end where id = “$search_key” limit 1

正解
update prof1 set k_number = case when k_number is null then 1 else k_number +1 end where id = “$search_key” limit 1