/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

8 votes284 views3 answers
Alter user root mysql
SQL
0 vote303 views1 answer
Mysql 3 months ago
SQL
1 vote279 views1 answer
Hexadec to sql REDSHIFT
SQL
2 votes284 views1 answer
Sql server case sensitive search
SQL
1 vote260 views1 answer
Delete mysql from mac
SQL
21 votes273 views4 answers
Oracle add column
SQL
0 vote338 views1 answer
Postgres extract number from string
SQL
1 vote263 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote260 views2 answers
Cascade syntax in sql
SQL
4 votes272 views3 answers
Drop Table Oracle
SQL

Share