Is this a documented behavior of MySQL(?): mysql> create table test (a int); Query OK, 0 rows affected (0.03 sec)
mysql> insert into test values(0); Query OK, 1 row affected (0.00 sec) mysql> insert into test values(0); Query OK, 1 row affected (0.00 sec) mysql> insert into test values(1); Query OK, 1 row affected (0.00 sec) mysql> insert into test values(2); Query OK, 1 row affected (0.00 sec) mysql> insert into test values(3); Query OK, 1 row affected (0.00 sec) mysql> select x.a from test x where 1; +------+ | a | +------+ | 0 | | 0 | | 1 | | 2 | | 3 | +------+ 5 rows in set (0.00 sec) mysql> select * from test where 0; Empty set (0.00 sec) mysql> select x.a from test x where x.a; +------+ | a | +------+ | 1 | | 2 | | 3 | +------+ 3 rows in set (0.00 sec) mysql> select x.a from test x where 'a'; Empty set (0.00 sec) mysql> --------------------------------------------------------------------- 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
