MYSQL与ORACLE 条件查询会过滤NULL的问题

null值与任意值比较时都为fasle

not in 、"!="、"not like"条件过滤都会过滤掉null值的数据

SELECT * from temp;

SELECT * from temp where score not in (70);

 

 返回null解决方法:

SELECT * from temp where score not in (70) or score is null;

-- mysql
SELECT * from temp where score IFNULL(score,'') != 70;

-- oracle
SELECT * from temp where score nvl(score,'') != 70;