Checking whether a value IS NOT NULL using MySQL:

2 IS NOT UNKNOWN/th>	0 IS NOT UNKNOWN	NULL IS NOT UNKNOWN
1	1	0