/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 vote172 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote193 views1 answer
Create table split string function in sql server
SQL
0 vote190 views1 answer
Minus equivalent in my sql
SQL
0 vote163 views1 answer
Mysql cdn link
SQL
0 vote174 views1 answer
Mysql count number of occurrences in a column
SQL
3 votes208 views3 answers
Create table in SQL Server
SQL
23 votes181 views5 answers
Sql substring
SQL
0 vote191 views1 answer
Mysql delete from where like
SQL
0 vote179 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote180 views1 answer
How to update sql server version
SQL

Share