how to select null values in a table - Mysql
select null values
Snippet Code
Rate this page :
|
[ 0 votes]
|
In some cases we are in need of selecting only null values from a table. Hence use IS condition as,
SELECT * FROM table_name WHERE COLUMN IS NULL
eg,
SELECT * FROM test WHERE sitename IS NULL
