Mysql查找字段空、不为空的方法

不为空


select * from table where id <> ''
select * from table where id !=''

为空


select * from table where id=''
select * from table where ISNULL(id)