CodingForums.com - View Single Post - difference between 'is null' and '= null'

Celtboy · 02-25-2013, 04:53 PM

You'll want to use IS NULL. = NULL is an arithmetic operator that can have some odd results:

http://dev.mysql.com/doc/refman/5.0/...with-null.html

02-25-2013, 04:53 PM	PM User \| #2
Celtboy Regular Coder Join Date: May 2002 Location: Virginia, USA Posts: 620 Thanks: 0 Thanked 6 Times in 6 Posts	You'll want to use IS NULL. = NULL is an arithmetic operator that can have some odd results: http://dev.mysql.com/doc/refman/5.0/...with-null.html