Re: Query problem
| From: | Dirk Kredler | Date: | Tue, 22 Jul 2003 09:29:58 +0000 |
| Subject: | Re: Query problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29384@lists.php.net to get a copy of this message | ||
Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen:
> This is what I have
> select * from ticket where Type = 'Line' and Closeddate = ' empty space'
> and have tried the following
> select * from ticket where Type = 'Line' and Closeddate = 'Null'
> select * from ticket where Type = 'Line' and Closeddate = 'NULL'
use
isNULL(Closedate) instead of Closedate = 'NULL'