IS NOT NULL not working in MySQL

[Roya Rateshtari]

Hi everyone,

Hope somebody can help me with the following issue.

I run

select `site`, `cookie_id` from `page` where `cookie_id` is not null;

And it still returns the NULL values.

---------------------
site - cookie_id
---------------------
xxx - NULL
---------------------
yyy - NULL
---------------------
zzz - 008gbhkl9jj
---------------------


* both site and cookie_id are varchar(32) and allowing NULL value.
* MySQL Version = 5.1.31.


Why? ... Any solution?
Thanks

Roya