筛选空值
where column.name is null
筛选非空值
where column.name is not null
筛选空字符串
where LENGTH(trim(column.name)) = 0
筛选非空字符串
where LENGTH(trim(column.name)) > 0
筛选非空值且非空字符串
where column.name is not null
and LENGTH(trim(column.name)) > 0