Function MySQL

  1. Home
  2. MySQL
  3. Function
  4. The IFNULL() function returns a value based on whether a specified expression evaluates to NULL
mysql>
IFNULL(, )
mysql>
The function returns  if it is not NULL;
otherwise, it returns .
mysql>
mysql> SELECT IFNULL(10*NULL, 'expression incorrect');
+-----------------------------------------+
| IFNULL(10*NULL, 'expression incorrect') |
+-----------------------------------------+
| expression incorrect                    |
+-----------------------------------------+
1 row in set (0.00 sec)
mysql>