sqlserver数据库查询某个字段 为null的所有行数据
9999.00 (库存:有货)
已超出库存数量!
thinkphp语法:
$mcardcategory=D('tcardcategory');
$cardcategory_information=$mcardcategory->where("CardNumber='1263' and (ISNULL(IsExchange, '')='' or IsExchange='是')")->select();
原生sql:
SELECT * FROM tcardcategory WHERE ( CardNumber='1263' and (ISNULL(IsExchange, '')='' or IsExchange='是') );