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

0 vote280 views1 answer
Postgres : ERROR: division by zero
SQL
7 votes267 views1 answer
Sql management studio display line numbers
SQL
0 vote283 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
1 vote228 views1 answer
Mysql see column types
SQL
2 votes277 views1 answer
Mysql query unique column
SQL
2 votes267 views1 answer
Postgresql format date dd/mm/yyyy
SQL
5 votes278 views2 answers
Get columns number sql
SQL
23 votes278 views4 answers
Sql server substring
SQL
7 votes287 views3 answers
Sql fill table with info from anothe rtable
SQL
2 votes275 views2 answers
Get all columns from table sql
SQL