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

Tags


Ask Questions

Ask Question