if
select if(false,'ok','error');
效果展示
ifnull
select ifnull('ok','default');
效果展示
``
select ifnull('','default');
效果展示
select ifnull(null,'default');
效果展示
case when then else end
select uid,
case exam_id when '9001'
then '简单'
when '9002'
then '非常难'
else '试卷编号错误' end as difficult
from smbms.exam_record;
效果展示