/SQL/If null mysql

If null mysql

Mysql where value is null

SELECT *
FROM contacts
WHERE last_name IS NULL;

9

Check if value is null mysql

SELECT * from TABLE where CODE IS NULL OR CODE!='C'

4

Source: stackoverflow.com

Mysql if null

IFNULL(MAX(EMAIL), "example@google.com") as email

2

If null mysql

SELECT IFNULL(NULL, "W3Schools.com");

0

If column value is null then in mysql

 SELECT 
    contactname, IFNULL(bizphone, homephone) phone
FROM
    contacts;

0

Source: mysqltutorial.org

Similar codes

5 votes169 views1 answer
Mysql get last day of month
SQL
9 votes221 views4 answers
Oracle get table column names
SQL
0 vote240 views1 answer
How to find top 3 salary in sql
SQL
4 votes173 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote268 views1 answer
Trigger
SQL
5 votes220 views4 answers
Rollback to in sql
SQL
3 votes205 views2 answers
Sql not contains
SQL
0 vote183 views1 answer
Sql select column names starting with
SQL
16 votes200 views2 answers
Sql vs nosql
SQL
16 votes180 views2 answers
Mysql date between two dates
SQL

Share