Testing whether a value is NULL using MySQL. It returned 1 if the value id NULL else returns 0:

2 IS NULL	0 IS NULL	NULL IS NULL
0	0	1