In MySQL, NULL represents an unknown value. A NULL is never equal to any, even another NULL. Operator returns true if column value is NULL.
Step 1 - First we will create the database.
![mysql1](http://www.dbtalks.com/article/introduction-to-mysql2/Images/1.jpg)
![mysql2](http://www.dbtalks.com/article/introduction-to-mysql2/Images/2.jpg)
Here I created the database with name mindcracker.
Step 2 - Now we will create the table.
![mysql3](http://www.dbtalks.com/article/introduction-to-mysql2/Images/3.jpg)
So our table student is created.
Step 3 - Now we will insert values in our table.
![mysql4](http://www.dbtalks.com/article/introduction-to-mysql2/Images/4.jpg)
![mysql5](http://www.dbtalks.com/article/introduction-to-mysql2/Images/5.jpg)
So here is the created table.
Step 4 - Now we write the following MySql query to fetch the student where name is NULL.
![mysql6](http://www.dbtalks.com/article/introduction-to-mysql2/Images/6.jpg)
Summary
Here we see that to fetch the student with NULL value we have not write the select query like this
- select * from student where name=NULL;
Because we know that NULL value can't be equal to a value. So to fetch the student with
NULL value we have to use is keyword with where clause in select statement.