How To Check Nulls In MySQL Database Table

Assuming QuantityPerUnit is the field to be tested.

-- return products with no null values  
select * from products where QuantityPerUnit is not null;  
-- return products with null values  
select * from products where isnull(QuantityPerUnit);