問題描述：

MySQL庫存(store)字段為null，判斷了庫存導(dǎo)致SQL無法查詢結(jié)果?

$sql = "SELECT a.image_default_id,b.product_id,b.price,b.mktprice,b.name FROM `sdb_b2c_goods` AS a 
                    INNER JOIN sdb_b2c_products AS b ON a.goods_id=b.goods_id
                    WHERE a.marketable='true' 
                    AND a.verify='1' 
                    AND a.disabled='false'
                    AND b.disabled='false'
                    AND b.store>b.freez
                    AND (b.store-b.freez)>0
                    AND b.product_id IN ($productId)
                    ORDER BY FIELD(product_id,{$productId})";

如何將store為null的時(shí)候 強(qiáng)制轉(zhuǎn)換為int類型呢?

解決方法：

IFNULL(store, 0);