IS NULL ISNULL « Comparison Functions Operators « MySQL Tutorial






15.9.IS NULL ISNULL
15.9.1.IS NULL
15.9.2.IS NOT NULL: Tests whether a value is not NULL
15.9.3.Check to see if the first name is NULL
15.9.4.ISNULL(expr): If expr is NULL, ISNULL() returns 1, otherwise it returns 0
15.9.5.SELECT ISNULL(1/0);
15.9.6.Using ISNULL in where clause
15.9.7.Using ISNULL with data in a table