Re: Re: Database Problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jun 25, 2012 at 7:57 AM, Peter Beckman <beckman@xxxxxxxxxxx> wrote:
>  I'll save you some time, it's not the "where 1" part of the query:
>
>    mysql> select count(*) from numbers where 3 and num like '1212%';

The only time the where clause fails (rightly so) with a single number
like what is when you do "where 0".

mysql> select count(*) from quotes where 0;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from quotes where 1;
+----------+
| count(*) |
+----------+
|      727 |
+----------+
1 row in set (0.00 sec)

Note that the where clause failing does NOT mean the select failed. It
correctly returned 0 rows.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux