Re: BLOB
| From: | Ricardo Lopes | Date: | Fri, 12 Mar 2004 09:34:07 +0000 |
| Subject: | Re: BLOB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33412@lists.php.net to get a copy of this message | ||
i think this is the right sintax:
SELECT * FROM
MEMBER WHERE ISNULL(PASSWD)
Passwd is a blob, that is an interesting name for a blob field, what are you
planing to do?
----- Original Message -----
From: "Ng Hwee Hwee" <hhwee@towa.com.sg>
To: "DBList" <php-db@lists.php.net>
Sent: Friday, March 12, 2004 4:39 AM
Subject: [PHP-DB] BLOB
Hi all,
how do i find out if a BLOB field in my table is NULL?
i tried:
SELECT * FROM MEMBER WHERE PASSWD is NULL
however, although there is one entry in my table that has nothing in my
PASSWD field, the result set is empty.. how come?
how do i search for entries that has password = [BLOB - 0 bytes] ??
thanx so much!!
huihui