2011/2/22 Joerg Bruehe <joerg.bruehe@stripped>:
> 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>
