1 message in com.mysql.lists.mysqlSearch in date field
FromSent OnAttachments
Christian Thiele02 Dec 2000 10:08 
Subject:Search in date field
From:Christian Thiele (Chri@gmx.de)
Date:12/02/2000 10:08:47 AM
List:com.mysql.lists.mysql

Hi,

can anybody help me, I want to search a age rage in my database, like ages
between 16-25 years old.

I tried "... where birthday BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL $afrom YEAR)
AND // DATE_SUB(CURRENT_DATE, INTERVAL $ato YEAR)"

birthday is field date with "1954-11-2"

But so I always get a empty result...who can help me?? Please...

Thanks

Bye Christian