Re: Query problem
| From: | Ron Allen | Date: | Tue, 22 Jul 2003 11:25:01 +0000 |
| Subject: | Re: Query problem | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29392@lists.php.net to get a copy of this message | ||
How would the entire query look
select * from ticket where Type = 'Phone' and ???????
"Dirk Kredler" <dirk@computication.net> wrote in message
news:200307221129.59337.dirk@computication.net...
> 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'
>
>