Mysql同时处理null值或空值为固定类的字符串

# 语法：IF(expr1,expr2,expr3)，如果expr1的值为true，则返回expr2的值，如果expr1的值为false，则返回expr3的值。是一个简单的三目表达式。

   SELECT COUNT(DISTINCT(id)) AS '企业数',if(country  ='' or country is null,'中国',country)  AS '注册国家' 
     FROM enterprise 
    WHERE is_investment_platform =0            # 是否投资平台 0否1是
			AND business_status != '注销'
			AND business_status != '迁出' 
      AND business_status != '转让'
			AND fictitious = 0                       # 虚拟公司  0否1是
			AND is_del = 0                           # 未逻辑删除
      AND plate_code IN (SELECT plate_code FROM plate_config WHERE plate_name='城市运营')   # 城市运营  
 GROUP BY country;