mysql 初学，问个小问题

[hbjmdx008]

t1表，字段a int ,b varchar(20)

a , b

1 null
2 null

===================
想查 b 不等于1的 可是下边两个sql总是查不到

select * from t1 where b<>1
select * from t1 where b<> '1'

[懒得去死]

select * from t1 where ifnull(b,0)<>1;

[klan]

try:

select * from t1 where ifnull(b,-1)<>1;