Mysql ifnull

Mysql else if

IF condition1 THEN
    statements;
ELSEIF condition2 THEN # OPTIONAL
	statements;
ELSE # OPTIONAL
    statements;
END IF;

Mysql ifnull

##syntax:
SELECT IFNULL(col_with_null_value, default_value);

##you can see the result select with the string NA where the document is null:
SELECT IFNULL(user_document_id, 'NA');

Mysql if null

IFNULL(MAX(EMAIL), "example@google.com") as email

If column value is null then in mysql

 SELECT 
    contactname, IFNULL(bizphone, homephone) phone
FROM
    contacts;

Source: mysqltutorial.org

Similar codes

2 votes183 views1 answer
Oracle to_char number format percentage
SQL
3 votes171 views2 answers
How to View column names of a table in SQL
SQL
0 vote270 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
15 votes177 views2 answers
How to know the username of postgresql
SQL
0 vote171 views1 answer
Access refused mysql xampp server
SQL
1 vote170 views1 answer
Mysql remove last empty newline
SQL
0 vote134 views1 answer
Jooq finding lastest value in table
SQL
5 votes198 views1 answer
Sql integer to serial
SQL
1 vote170 views3 answers
Mysql Server Start
SQL
0 vote180 views1 answer
Order by ip address sql
SQL