mysql当周过生日的人,我如何获得使用MYSQL和PHP在本周，本月和下个月庆祝生日的朋友的生日？...

I am currently working in an site which needs to get the birthdays of friends who are celebrating their birthday this week, this month and next month using MYSQL and PHP.

How would I go about this?

解决方案

Provided you store birthdates in DATE (or DATETIME) format in MySQL you can use the following Queries:

// This week

SELECT * FROM person WHERE WEEK( birthdate ) = WEEK( NOW() )

// This month

SELECT * FROM person WHERE MONTH( birthdate ) = MONTH( NOW() )

// Next month

SELECT * FROM person WHERE MONTH( birthdate ) = MONTH( NOW() ) + 1;

SELECT * FROM person WHERE IF

( MONTH( NOW() ) < 12, MONTH( birthdate ) = MONTH( NOW() ) + 1,

MONTH( birthdate ) = 1)