1 代码
1.1 当当前字段为空,查询结果返回“none”,并且统计出现频率
1
|
select
case
when
字段
is
null
then
'none'
else
字段
end
as
字段,
count
(1)
as
counts
from
表
group
by
字段;
|
1.2 当当前字段为空字符串,查询结果返回“none”,并且统计出现频率
1
|
select
case
when
字段=
''
then
'none'
else
字段
end
as
字段,
count
(1)
as
counts
from
表
group
by
字段;
|
1.3 当当前字段为空,查询结果返回“none”
1
|
select
case
when
字段
is
null
then
'none'
else
字段
end
as
字段
from
表;
|
1.4 当当前字段为空字符,查询结果返回“none”
1
|
select
case
when
字段=
''
then
'none'
else
字段
end
as
字段
from
表;
|
2 小结
仅作为记录使用,mysql其它相关命令有isnull,ifnull and nullif。