Nelson:
I have double checked my last post, and the following works:
"
SELECT
DISTINCT(FLOOR((datediff(curdate(), dateofbirth)/365))) as age,
COUNT(FLOOR((datediff(curdate(), dateofbirth)/365))) AS total_age
from myTable
group by age
"
Tell us if it worked for you.
Regards,
Alvaro
On 9/17/06, cnelson@stripped <cnelson@stripped> wrote:
>
> > If your dateOfBirth is a date field,
>
> It is.
>
> > you can do this:
> >
> > select
> > (substring(curdate(),1,4)-substring(dateofbirth,1,4))-
> > (substr(curdate(),5)<substr(dateofbirth,5))
> > as age
> > from myTable;
>
> Thanks. That's a little more accurate (thought that doesn't quite
> matter in my case).
>
>
> > But you can't get a group by from an alias.
>
> That surprises me. I tried putting the calculation of age in a
> subquery but that didn't work, either. And I've never quite figured
> out how to create a temporary table for intermediate results. There
> has _got_ to be a way to do this, even an awkward way.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
