在mysql中concat函数有一个特点就是有一个值为null那么不管第二个字符有多少内容都返回为空了
SELECT CONCAT(IFNULL(isdcode,''),telephone) FROM gb_customer
SELECT CONCAT(IFNULL(isdcode,''),telephone) FROM gb_customer
select c1,
(case when c2 = '' or c2 is null then 'default-value' else c2 end)
from test;