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 vote160 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote150 views1 answer
How to install sql in anaconda
SQL
3 votes165 views1 answer
Select sequence oracle
SQL
2 votes210 views1 answer
Oracle block
SQL
0 vote165 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote159 views1 answer
How to find all children of a record with only parent ID in sql
SQL
1 vote148 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
2 votes157 views1 answer
Update trigger
SQL
1 vote167 views2 answers
Mysql error 1215
SQL
3 votes145 views1 answer
Oracle revoke grant
SQL