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

5 IS TRUE	0 IS TRUE	NULL IS UNKNOWN
1	0	1