Try : SELECT * From table WHERE `address` = ''
Or SELECT * From table WHERE `address` IS NULL -----Ursprüngliche Nachricht----- Von: Caroline Jen [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Februar 2004 20:17 An: [EMAIL PROTECTED] Betreff: How To Write This SQL Statement Please help. What is the syntax of idenfying those who "do not" have addresses (in the address field) in the database? __________________________________ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]