Jeremy Zawodny wrote:
>
> On Tue, Jun 05, 2001 at 02:18:15PM -0500, Mark Stosberg wrote:
> >
> > However, if I ask for the rows where last_visit = NULL, it says there are
> > not any! :
> > mysql> select user_id,screen_name,password,last_visit,
> > second_to_last_visit from users where last_visit = NULL;
>
> What if you use "last_visit IS NULL"?
>
> (Hint: That's the correct syntax.)
Thanks, this works. I still think MySQL behaved poorly by not either:
a), accepting my syntax, or B.) throwing an error that the syntax was
incorrect. The result it returned appeared incorrect.
-mark
http://mark.stosberg.com/
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
