!= 和 <> 和 is not null
//不会查出字段是null的数据
SELECT * FROM table WHERE IsDeleted <> true AND name LIKE '%%' ;
SELECT * FROM table WHERE IsDeleted != true AND Name LIKE '%%';
//可以查出字段是null的数据
SELECT * FROM table WHERE IsDeleted is not true AND name LIKE '%%' ;
//会把有内容的和内容为空的都查出来
select * from table where a is not null;
//只会把有内容的查出来
select * from table where a != ''/"";