mysql可以选出数据为空的记录么?

wakelay 发布于 2013/05/26 10:50
阅读 233
收藏 0

user表有一条记录address 显示NULL 类型是char(50),

我试过:

select * from user where address="";

select * from user where address='';

select * from user where address=null;

select * from user where address=NULL;

都是显示没有结果啊。。