MySQL Linux Ubuntu CentOS PHP Windows CSS3
2021年7月07日- 書箋
//不會查出字段是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 '%%'