[EMAIL PROTECTED] wrote:
I did not expect that null was not not-equal to 1.
Any comparison with NULL returns NULL: mysql> select null<>1,null>1,null<1,null=1; +---------+--------+--------+--------+ | null<>1 | null>1 | null<1 | null=1 | +---------+--------+--------+--------+ | NULL | NULL | NULL | NULL | +---------+--------+--------+--------+ 1 row in set (0.00 sec) This is the correct and desired behaviour. <URL: http://dev.mysql.com/doc/mysql/en/null-values.html > <URL: http://dev.mysql.com/doc/mysql/en/working-with-null.html > <URL: http://dev.mysql.com/doc/mysql/en/problems-with-null.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]