{"id":2372,"date":"2013-05-14T22:23:53","date_gmt":"2013-05-15T06:23:53","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=2372"},"modified":"2020-04-11T02:02:20","modified_gmt":"2020-04-11T09:02:20","slug":"mysql-ifnull","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-control-flow-functions\/mysql-ifnull\/","title":{"rendered":"MySQL IFNULL"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn about the MySQL IFNULL<\/strong> function, which is a very handy control flow function to handle NULL values.<\/p>\n\n\n\n

Introduction to MySQL IFNULL function<\/h2>\n\n\n\n

MySQL IFNULL<\/code> function is one of the MySQL control flow functions that accepts two arguments and returns the first argument if it is not NULL<\/code>. Otherwise, the IFNULL<\/code> function returns the second argument.<\/p>\n\n\n\n

The two arguments can be literal values or expressions.<\/p>\n\n\n\n

The following illustrates the syntax of the IFNULL<\/code> function:<\/p>\n\n\n

IFNULL(expression_1,expression_2);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The IFNULL<\/code> function returns expression_1<\/code> if expression_1<\/code> is not NULL<\/code> ; otherwise, it returns expression_2<\/code>. The<\/p>\n\n\n\n
The IFNULL<\/code> function returns a string or a numeric based on the context where it is used.<\/p>\n\n\n\n
If you want to return a value based on TRUE<\/code> or FALSE<\/code> condition other than NULL<\/code>, you should use the IF function<\/a>.<\/p>\n\n\n\n
MySQL IFNULL function examples<\/h2>\n\n\n\n
See the following IFNULL<\/code> function examples:<\/p>\n\n\n
SELECT<\/span> IFNULL<\/span>(1<\/span>,0<\/span>); -- returns 1<\/span>\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span> IFNULL<\/span>(''<\/span>,1<\/span>); -- returns ''<\/span>\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span> IFNULL<\/span>(NULL<\/span>,'IFNULL function'<\/span>); -- returns IFNULL function<\/span><\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
How it works.<\/p>\n\n\n\n
Try It Out<\/a><\/p>\n\n\n\n
Try It Out<\/a><\/p>\n\n\n
Try It Out<\/a><\/p>\n\n\n