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
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
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