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 vote697 views1 answer
Create pl/sql stored procedure
SQL
0 vote372 views1 answer
Oracle tablespace autoextend
SQL
2 votes357 views1 answer
Oracle current date without time
SQL
0 vote352 views1 answer
Renommer schema sql
SQL
0 vote362 views1 answer
Mysql join only one column
SQL
0 vote338 views1 answer
Update top 100 sql
SQL
0 vote347 views1 answer
Run postgresql dump to csv
SQL
0 vote407 views2 answers
Unique key
SQL
0 vote350 views1 answer
Get records in sql according to month name and count
SQL
0 vote366 views1 answer
Oracle DROP PROGRAM
SQL