/SQL/Check if value is null mysql

Check if value is 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

Similar codes

50 votes125 views4 answers
Sql alter type of column
SQL
4 votes114 views2 answers
Postgresql reset sequence
SQL
0 vote117 views1 answer
Multiple tricky query in sql server
SQL
1 vote111 views1 answer
Update and replace mysql
SQL
0 vote110 views1 answer
Get null value in sql
SQL
17 votes123 views6 answers
Change column name in sql
SQL
0 vote123 views1 answer
Alter rename command in mysql
SQL
0 vote118 views1 answer
Oracle current timestamp
SQL
0 vote117 views1 answer
Mysql match in serialized data
SQL
0 vote128 views2 answers
Clauses in mysql
SQL

Share