RE: Newbie: Searching for empty fields

On Wednesday, March 23, 2005 12:13, Graham Anderson wrote: > how do you search for an empty field ? > I want to filter out records where the ipAddress field is empty > > SELECT * FROM 'userLog' WHERE 'ipAddress' IS [empty] ? Searching for NULL's -- SELECT * FROM userLog WHERE ipAddress IS NUL

Newbie: Searching for empty fields

how do you search for an empty field ? I want to filter out records where the ipAddress field is empty SELECT * FROM 'userLog' WHERE 'ipAddress' IS [empty] ? many thanks g -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAI