Checking whether a value IS NOT NULL using MySQL:

5 IS NOT NULL	0 IS NOT NULL	NULL IS NOT NULL
1	1	0