Skip navigation links

MySQL Forums :: General :: IS NOT NULL not working in MySQL


Advanced Search

IS NOT NULL not working in MySQL
Posted by: Roya Rateshtari ()
Date: July 18, 2012 06:14AM

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

Options: Reply•Quote


Subject Written By Posted
IS NOT NULL not working in MySQL Roya Rateshtari 07/18/2012 06:14AM
Re: IS NOT NULL not working in MySQL Xhavick Past 07/18/2012 08:57AM
Re: IS NOT NULL not working in MySQL Peter Brawley 07/18/2012 09:57AM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.