When I do the following query in mySQL only 1 record is retrieved.  

SELECT * FROM `paypal_payment_info` WHERE `os1` NOT LIKE 'commission_paid' 

I am surprised by this.  This one record has no characters in it, but the 
“INSERT INTO” that created it used: ( `os1` ) VALUES ( ‘’ ) instead of: ( `os1` 
) VALUES ( NULL ) .  There are a number of records where `os1` is NULL.  I 
would like these rows to retrieve as well.  How do I make a WHERE clause for a 
cell that is NULL ?  


The Verse of the Day
“Encouragement from God’s Word”

Reply via email to