MySQL Tips: Select Rows Where Column Is NULL

A NULL column is different from an empty column.

INSERT INTO TableName (ColumName) values (NULL);

INSERT INTO TableName (ColumName) values ('');[sql]

The second will insert an empty string into ColumName. A SELECT query would be as easy as
[sql]SELECT * from TableName where ColumnName = '';

While to query for the column with the NULL value, we have to write the SELECT query as such:

SELECT * from TableName where ColumnName is NULL;