//不会查出字段是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 '%%'
//不会查出字段是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 '%%'