mysql case when then else 语法

update `badges` set `cat_point` =
　　 CASE WHEN level >= 1 THEN POW(2, `level` - 1) ELSE 0 END
　　where name not like '%Steam%';

 

if  level >=1 :

  cat_point = POW(2, `level` - 1)

else:

  cat_point = 0