468,242 Members | 1,613 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

check != NULL

tolkienarda
316 100+
hi all i need to check in a database to see if a value is null

i don't remember what i put in for null
Expand|Select|Wrap|Line Numbers
  1. mysql_query("SELECT name FROM dbase WHERE fcc != NULL");
  2.  
my question is the part where it is fcc != NULL correct of do i put a 0 or '' instead of null

thanks

eric
Apr 26 '07 #1
1 2290
michaelb
534 Expert 512MB
The correct syntax is
Expand|Select|Wrap|Line Numbers
  1. WHERE fcc IS NULL
  2. -- or
  3. WHERE fcc IS NOT NULL
  4.  
Apr 26 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Martin | last post: by
3 posts views Thread by GS | last post: by
1 post views Thread by shapper | last post: by
3 posts views Thread by Helen Wheels | last post: by
14 posts views Thread by Mark | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.