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_functions
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
