筛选不为空(’’)并且不为null:
SELECT * FROM 表名 WHERE 字段名 IS NOT NULL AND NOT 字段名 = ‘’;
SELECT * FROM 表名 WHERE 字段名 IS NOT NULL AND 字段名 <> ‘’;
SELECT * FROM 表名 WHERE 字段名 IS NOT NULL AND 字段名 != ‘’;
筛选不为空(’’)并且不为null:
SELECT * FROM 表名 WHERE 字段名 IS NOT NULL AND NOT 字段名 = ‘’;
SELECT * FROM 表名 WHERE 字段名 IS NOT NULL AND 字段名 <> ‘’;
SELECT * FROM 表名 WHERE 字段名 IS NOT NULL AND 字段名 != ‘’;