/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

0 vote119 views1 answer
Top 3 salary in sql
SQL
0 vote130 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote143 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote122 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote119 views1 answer
Sql server select ignore dupplicates
SQL
9 votes108 views1 answer
Sql server get utc date
SQL
3 votes110 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote126 views1 answer
Query builder doctrien return sql
SQL
1 vote108 views1 answer
Check constraint to check if date greater than todays date
SQL
1 vote131 views1 answer
Mysql find tables with column name
SQL

Share