mysql针对一张表查询一条或多条数据

case when xxx then 
 when yyy then 
 when zzz then 
 else 0 end;              
----一行数据

case when xxx then else 0 end,
case when yyy then else 0 end,
case when zzz then else 0 end
----多行数据