如何处理空值?
正确的写法为:
CASE
WHEN var IS NULL THEN SELECT 'Hello';
ELSE SELECT 'world.';
END CASE;
而下面的写法却不能得到正确结果,这是因为:var = NULL" is not true .
CASE var
WHEN NULL THEN SELECT 'Hello';
ELSE SELECT 'world.';
END CASE;
http://dev.mysql.com/doc/refman/5.0/en/working-with-null.html
Working with NULL
Values
http://dev.mysql.com/doc/refman/5.1/en/case-statement.html
CASE Statement