mysql 时间查询

[l2x11]

字段 birthday date() 类型 （2000-12-25）

我欲查询今天过生日的

1.
SELECT user_id,user_name,user_pic,baby_sex,baby_birthday,province,city,area,baby_name FROM user WHERE month(baby_birthday) = month( now( ) ) AND date(baby_birthday) = date(now())

2.
SELECT user_id,user_name,user_pic,baby_sex,baby_birthday,province,city,area,baby_name FROM user WHERE month(baby_birthday) = month( now( ) ) AND to_days(baby_birthday) = to_days(now())
3.
SELECT user_id,user_name,user_pic,baby_sex,baby_birthday,province,city,area,baby_name FROM user WHERE month(baby_birthday) = month( now( ) ) AND date(baby_birthday) = curdate()

月份能正确查询出来，但今天的就是没有查询出来，数据库有今天过生日的。

[aiur]

month(baby_birthday) = month( now( ) ) AND DAYOFMONTH(baby_birthday) = DAYOFMONTH(now())

[程序猿之殇]

如果baby_birthday是datetime类型的,是没有问题的.

[xuzuning]

.... DATE_FORMAT(baby_birthday,'%Y%d') = DATE_FORMAT(now(),'%Y%d')

简洁直观，与php的date函数很相似