SELECT * FROMM TB WHERE 字段 IS NULL OR 字段='' 判断某个字段不为空 select * from table(表名) where trim(column) != '';