Re: Grouping functions inside WHERE clause - may or not

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 the mySQL manual i red the following into "Functions to use in SELECT and WHERE clauses/Comparision operators" section: "If expr is a TIMESTAMP, DATE, or DATETIME column, MIN() and MAX() are formatted to the same format if they are constants." What this means? may i use min()/max() into WHERE or not?

1) The WHERE clause is used to determine which records to select. 2) MIN() and MAX() are determined based on the values of the selected records. You draw the conclusion. However, you may be able to use user-defined variables to do what you want. Execute a couple of queries: SELECT @dmin := MIN(date_field), @dmax := MAX(date_field) FROM tablename; SELECT date_field FROM tablename WHERE date_field BETWEEN @dmin and @dmax; By the way, this is a PHP list. What's your PHP question?

Pls help! -- ________________________________ Ventsyslav Vassilev Comel Soft Multimedia Sofia, Bulgaria ICQ UIN: 11199819 e-mail: wency@comelsoft.com

-- Paul DuBois, paul@snake.net