Mysql Programming Tips & Tricks





Español Français 中文 Deutsch Portuguese Japanese nederlands
   
 
Code Snippets
 List All
 Datatypes
 Other Queries
 Tables
 




how to select null values in a table - Mysql

Snippets  Mysql  How to select null values in a table
Snippet On
select null values




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




Other Links

web hosting