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" <[EMAIL PROTECTED]> To: "DBList" <[EMAIL PROTECTED]> 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
