查询MySql数据库，查看当前日期后30天内“生日”日期字段的条目

Question

I am trying to write a PHP script that queries a MySql database and returns the entries for which the Birthday date field is within the next 30 days. I am able to do this, but I need to exclude the year from the Birthday date when making the query. For example, if today's date is 7/10/2013, and the birthday in question is 7/13/1991, obviously these two dates are more than 30 days apart, but if we exclude the year, they are only 3 days apart. Making this a valid Birthday to return.

The Birthday field is stored as a DATE in the MySql database.

The query I have made so far:

$results = mysql_query("SELECT * FROM Club WHERE Birthday < DATE_SUB(NOW(), INTERVAL 30 DAY)");

What can I do to modify this query to not take the year into account?

Answer 1

Is this what you're looking for?

SELECT * FROM Club WHERE month(Birthday) = month(DATE_SUB(NOW(), INTERVAL 30 DAY)) and dayofmonth(Birthday) = dayofmonth(DATE_SUB(NOW(), INTERVAL 30 DAY));

http://pastebin.com/uEXrXrHT