Easy Tutorial
Mysql Administration Mysql Func Ifnull Mysql Like Clause Mysql Operator Mysql Create Tables Mysql Data Types Mysql Database Info Mysql Group By Statement Mysql Regexp Mysql Database Import Mysql Select Query Mysql Select Database Mysql Temporary Tables Mysql Tutorial Mysql Using Sequences Mysql Drop Tables Mysql Connection Mysql Insert Query Mysql Index Mysql Install Mysql Functions Mysql Sql Injection Mysql Delete Query Mysql Transaction Mysql Php Syntax Mysql Union Operation Mysql Clone Tables Mysql Handling Duplicates Mysql Null Mysql Create Database Mysql Join Mysql Alter Mysql Update Query Mysql Where Clause Mysql Database Export Mysql Order By Mysql Drop Database
❮ Mysql Administration Mysql Like Clause ❯

MySQL IFNULL() Function

MySQL Functions

The IFNULL() function is used to check if the first expression is NULL. If it is NULL, it returns the value of the second parameter; if it is not NULL, it returns the value of the first parameter.

The syntax for the IFNULL() function is:

IFNULL(expression, alt_value)

If the expression in the first argument is NULL, it returns the alternative value from the second argument.

Parameter Description:

Parameter Description
expression Required, the value to test
alt_value Required, the value to return if the expression is NULL

Examples

First argument is NULL:

SELECT IFNULL(NULL, "tutorialpro");

The output for the above example is:

tutorialpro

First argument is not NULL:

SELECT IFNULL("Hello", "tutorialpro");

The output for the above example is:

Hello

MySQL Functions

❮ Mysql Administration Mysql Like Clause ❯