Query problem
| From: | Ron Allen | Date: | Tue, 22 Jul 2003 09:29:01 +0000 |
| Subject: | Query problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29383@lists.php.net to get a copy of this message | ||
I have done this in the past, but for some reason it isn't working now
(maybe a moron). I am trying to select all of the empty or NULL fields in a
column.
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'
any clues ????