List:General Discussion« Previous MessageNext Message »
From:Carsten Pedersen Date:December 28 2009 10:41pm
Subject:Re: Is anything ever equal to NULL?
View as plain text  
David Giragosian skrev:
> On Mon, Dec 28, 2009 at 2:32 PM, D. Dante Lorenso <dante@stripped> wrote:
> 
>> Will anything ever be equal to NULL in a SELECT query?

...

>> What's so special about NULL?
> 
> 
> http://dev.mysql.com/doc/refman/5.0/en/working-with-null.html
> 
> Should answer some of your questions, Dante.

Oddly enough, that page fails to mention the <=> operator for which NULL 
does indeed equal NULL.

http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_equal-to

/ Carsten

Thread
Is anything ever equal to NULL?D. Dante Lorenso28 Dec
  • Re: Is anything ever equal to NULL?Michael Dykman28 Dec
  • Re: Is anything ever equal to NULL?David Giragosian28 Dec
    • Re: Is anything ever equal to NULL?Carsten Pedersen28 Dec
      • Re: Is anything ever equal to NULL?David Giragosian29 Dec
  • Re: Is anything ever equal to NULL?Martijn Tonies28 Dec
    • Re: Is anything ever equal to NULL?D. Dante Lorenso29 Dec
    • Re: Is anything ever equal to NULL?Joerg Bruehe29 Dec
  • Re: Is anything ever equal to NULL?Martijn Tonies29 Dec