http://www.mysql.com/documentation/mysql/full/manual_toc.html#Working_with_NULL
On 12 Sep 2002, compo guy wrote:
> What is the difference between the following sql queries written
> to
> >extract tuples with the field amount having non null value:
> > select loan_number from loan where amount <> null (It
> >returns
> >an empty set)
> > select loan_number from loan where amount is not null(It
> >returns the expected result).
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread119402@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-vsurlan=student.math.hr@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
