> And why do you think it should return 0 ?
>
> ( 1 < 5 ) returns 1.
> ( 1 < 3 ) returns 1.
> ( 1 < 5 < 3 ) should then return 1.
>
> Or am I missing something?
>
I think probably becuse ( 5 < 3 ) returns 0.
Depends how you read it, either as "1 is less than 5 and less than 3" or "1
is less than 5 and 5 is less than 3".
Of course the real question is "how does MySQL read it?" :-)
Cheers
Jon
**********************************************************************
'The information included in this Email is of a confidential nature and is
intended only for the addressee. If you are not the intended addressee,
any disclosure, copying or distribution by you is prohibited and may be
unlawful. Disclosure to any party other than the addressee, whether
inadvertent or otherwise is not intended to waive privilege or confidentiality'
**********************************************************************
---------------------------------------------------------------------
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
