Re: Grouping functions inside WHERE clause - may or not

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 MAX() are formatted to the same format if they are constants." +, i still do not understand above passage from MySQL manual have a nice day... "Paul Dubois" <paul@snake.net> wrote in message news:p04330106b791e5e07dfd@[192.168.1.31]... > 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