字段 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()月份能正确查询出来,但今天的就是没有查询出来,数据库有今天过生日的。
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()月份能正确查询出来,但今天的就是没有查询出来,数据库有今天过生日的。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货