IFNULL « Control Flow Functions « MySQL Tutorial






18.4.IFNULL
18.4.1.IFNULL(expr1,expr2)
18.4.2.Using IFNULL in where clause
18.4.3.Using IFNULL with data in a table
18.4.4.Create a table based on the result of IFNULL
18.4.5.IFNULL() with NULL and NOT NULL value
18.4.6.Use the IFNULL() function to specify a zero in place of the NULL figure