mysql如何判断是否为空

select * from user;

insert into user values('33',null);  ##创建一条name为空的数据

insert into user values('222','');  ##创建一条为空字符的数据

select * from user where ISNULL(name)=0 and LENGTH(trim(name))>0;