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

5 votes299 views1 answer
Sysdate in oracle sql
SQL
0 vote306 views1 answer
Mysql remove last character
SQL
1 vote319 views1 answer
Sql server if exists update else insert
SQL
0 vote282 views1 answer
Pl sql constraint user function
SQL
4 votes282 views1 answer
What are the data types in sql
SQL
0 vote243 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
11 votes274 views1 answer
How to get ddl for materialized view
SQL
0 vote270 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote322 views1 answer
Mysql login console
SQL
28 votes248 views6 answers
Distinct sql
SQL