On Jan 29, 11:31 pm, Carolyn Marenger <caj...@marenger.com> wrote:
> How do I perform a select statement that would locate all records in
> which the day and month are in the next say 30 days regardless of the
> year. Basically an upcoming birthday/anniversary list.
>
> Thanks, Carolyn
Have a look at the function date_sub(), and you find more date
functions here
http://dev.mysql.com/doc/refman/5.1/...functions.html.