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:[email protected]] Sent: dinsdag 22 februari 2011 13:20 To: Joerg Bruehe Cc: [email protected]; Almar van Pel Subject: Re: contact gives empty result 2011/2/22 Joerg Bruehe <[email protected]>: > 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/[email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
