Select * from your_table 
WHERE col1 and col2 and col3 and col4 and col5 IS NOT NULL;

这种方法的唯一缺点是，您只能比较5列，之后的结果将始终为假，所以我只比较可以为NULL的字段。

SELECT * FROM TABLE_NAME
where COLUMN_NAME <> '';

Mysql不是空的连接和选择，插入，删除和逻辑操作符像或，不是

Using IS NOT NULL On Join Conditions

 SELECT * FROM users 
 LEFT JOIN posts ON post.user_id = users.id 
 WHERE user_id IS NOT NULL;

 Using IS NOT NULL With AND Logical Operator

 SELECT * FROM users 
 WHERE email_address IS NOT NULL 
 AND mobile_number IS NOT NULL;

Using IS NOT NULL With OR Logical Operator

 SELECT * FROM users 
 WHERE email_address IS NOT NULL 
 OR mobile_number IS NOT NULL;

哪里的coalesce(所有的列)不是空的

SELECT duration,id FROM `tickets` WHERE duration !=""

以下查询为我工作

当我已经设置列'NULL'的默认值时

select * from table where column IS NOT NULL

当我设置默认值时，什么都没有

select * from table where column <>''