NULL values
| From: | Ron Piggott | Date: | Sat, 04 Dec 2010 02:25:40 +0000 |
| Subject: | NULL values | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47520@lists.php.net to get a copy of this message | ||
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 ?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info