IFNULL in MySQL

Given a TABLE, in this TABLE, it prints entry of the table. If table is empty then it gives NULL.

Examples:

QUESTION : Given an employee table, print name from the given table which id equals to 2.

Output : Geek2

QUESTION : Given same Employee table, print name from the given table which id equals to 5.
Output : NULL

Approach: In this case, we use here IFNULL. IFNULL print the null if the table is an empty or other condition.

Query:-

SELECT 
IFNULL(
  (SELECT NAME 
  from employee
  where id = 2),
  'NULL') as NAME;
Output:-
Geek2

Query:-

SELECT 
IFNULL(
  (SELECT NAME 
  from employee
  where id = 5),
  'NULL') as NAME;
Output:-
NULL


My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.




Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.