Hi Jaime, Joerg and All, Thanks for the explaining. In all those years I've never actually seen this, quite surprising actually :). In this case the comments field was empty and indeed not set. As it could be filled during the proces I'll be adding an empty string to the field. I still need to update it with additional text.
Best regards, Almar van Pel www.makeweb.nl -----Original Message----- From: Jaime Crespo Rincón [mailto:jcre...@warp.es] Sent: dinsdag 22 februari 2011 13:20 To: Joerg Bruehe Cc: mysql@lists.mysql.com; Almar van Pel Subject: Re: contact gives empty result 2011/2/22 Joerg Bruehe <joerg.bru...@oracle.com>: > You have not understood the concept of NULL in SQL: > NULL does not mean "empty", it means "unknown". [...] Apart form fully agreeing with Joerg, just a tip: you can use the the IFNULL() operand as a workaround: <http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_ifnull> Anyway, you should get rid of misplaced NULL fields, as they also affect performance. -- Jaime Crespo MySQL & Java Instructor Software Developer Warp Networks <http://warp.es> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=al...@makeweb.nl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
