RE: [PHP] Getting my head around nulls.
| From: | Johnson, Kirk | Date: | Tue, 25 Sep 2001 14:11:53 +0000 |
| Subject: | RE: [PHP] Getting my head around nulls. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-68706@lists.php.net to get a copy of this message | ||
> SELECT * from some_table WHERE some_field IS NULL;
>
>
> Andrey Hristov
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
Thanks for correcting my misspelling, Andrey, "IS NULL" not "IS_NULL".
Another thing to look at, Ben, is IFNULL(). I would give you an example, but
I never got it to work like I thought it should ;) I think it is supposed to
return an alternate value for NULLs.
Kirk