Re: [PHP-DB] Grouping functions inside WHERE clause - may or not

2001-08-05 Thread Ventsyslav Vassilev
10x Paul - i know that this is a PHP list, but PHP&MySQL are almost like husbands already:-)) In addition - in this list are being posted many mysql questions, right? It is PHP.DB... My purpose was to get results with one query only. "If expr is a TIMESTAMP, DATE, or DATETIME column, MIN() and MA

Re: [PHP-DB] Grouping functions inside WHERE clause - may or not

2001-08-04 Thread Paul DuBois
At 6:59 PM +0300 8/4/01, Ventsyslav Vassilev wrote: >Hi, >My simple question is: >May i use grouping functions in the WHERE clause of a SQL query in mySQL? > >For example, this failed to work: >SELECT date_field FROM tablename WHERE date_filed BETWEEN MIN(date_field) >AND MAX(date_field); > >In th

[PHP-DB] Grouping functions inside WHERE clause - may or not

2001-08-04 Thread Ventsyslav Vassilev
Hi, My simple question is: May i use grouping functions in the WHERE clause of a SQL query in mySQL? For example, this failed to work: SELECT date_field FROM tablename WHERE date_filed BETWEEN MIN(date_field) AND MAX(date_field); In the mySQL manual i red the following into "Functions to use in