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=arch...@jab.org