Once again, the best support on the planet!
Thanks, Paul.
--jim
-----Original Message-----
From: Paul DuBois <paul@stripped>
>At 9:37 AM -0500 5/19/99, jkraai@stripped wrote:
>>mysql> SELECT 0='', 1='';
>>+------+------+
>>| 0='' | 1='' |
>>+------+------+
>>| 1 | 0 |
>>+------+------+
>>
>>Is this SQL or MySQL behavior?
>>
>>Anyone know the rationale behind it?
>
>MySQL tries to perform type conversion whenever it can, rather than just
>give you an error.
>
>What results were you expecting?
>
>MySQL's comparison rules are listed at:
>
>http://www.mysql.com/Manual_chapter/manual_Reference.html#Comparison_functi
ons
>
>--
>Paul DuBois, paul@stripped
>Northern League Chronicles: http://www.snake.net/nl/
