Selecting a range of dates in MySql

[Jeff Roe]

I need to do a search in MySql for birth date range. (i.e. for birth date[color=blue]
>= 01/23/65 and <=12/31/03.)[/color]

Any suggestions on how to do this select?

Thanks!

[Tom Thackrey]

Re: Selecting a range of dates in MySql



On 1-Oct-2003, "Jeff Roe" <jdrut10@hotmai l.com> wrote:
[color=blue]
> I need to do a search in MySql for birth date range. (i.e. for birth date[color=green]
> >= 01/23/65 and <=12/31/03.)[/color]
>
> Any suggestions on how to do this select?[/color]

select * from xxxx where bdate>='1965-01-23' and bdate<='2003-12-31'

--
Tom Thackrey

https://www.creative-light.com