mysql case when 判断null

select  name,case WHEN m.NAME is null THEN '' else m.NAME end NAME1 from  sys_users

原文地址:https://www.cnblogs.com/wdw31210/p/9358567.html