my sql 查询语句

 

筛选不为空(’’)并且不为null:

SELECT * FROM 表名 WHERE 字段名 IS NOT NULL AND NOT 字段名 = ‘’;

SELECT * FROM 表名 WHERE 字段名 IS NOT NULL AND 字段名 <> ‘’;

SELECT * FROM 表名 WHERE 字段名 IS NOT NULL AND 字段名 != ‘’;