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

-1 vote216 views1 answer
Ms sql select datetime as date
SQL
2 votes215 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote243 views1 answer
Select top 3 sql
SQL
0 vote220 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
1 vote152 views1 answer
Postgres reset auto increment
SQL
0 vote270 views1 answer
Month mysql
SQL
0 vote228 views1 answer
SELECT statement to find the specific cell in database table
SQL
52 votes855 views6 answers
Rename column sql
SQL
0 vote262 views1 answer
Mysql default uuid
SQL
1 vote207 views1 answer
Update from select oracle
SQL