List:General Discussion« Previous MessageNext Message »
From:Jaime Crespo Rincón Date:February 22 2011 12:20pm
Subject:Re: contact gives empty result
View as plain text  
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:

Anyway, you should get rid of misplaced NULL fields, as they also
affect performance.

Jaime Crespo
MySQL & Java Instructor
Software Developer
Warp Networks
contact gives empty resultAlmar van Pel 22 Feb
  • Re: contact gives empty resultJoerg Bruehe22 Feb
    • Re: contact gives empty resultJaime Crespo Rincón22 Feb
      • RE: contact gives empty resultAlmar van Pel 22 Feb