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 vote289 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote264 views1 answer
Sql last 7 days
SQL
1 vote290 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote278 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
7 votes283 views1 answer
Xampp reset mysql
SQL
3 votes288 views2 answers
Search text in all sql server stored procedure
SQL
0 vote298 views1 answer
Sql decimal to 2 places
SQL
0 vote292 views1 answer
Oracle 11g forget password
SQL
0 vote304 views1 answer
Insert into table with only identity column
SQL
0 vote264 views1 answer
Postgresql log
SQL