/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

1 vote146 views1 answer
File /etc/init.d/mysql not exists
SQL
3 votes208 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote206 views1 answer
Sql get highest date from 3 tabels
SQL
1 vote181 views1 answer
Check message id sql server
SQL
1 vote204 views1 answer
Oracle nvl2
SQL
2 votes207 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote202 views1 answer
How to get table current identity value in sql server
SQL
0 vote191 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote211 views1 answer
Allow null in psql
SQL
0 vote196 views1 answer
Sql count more than 1
SQL

Share