Mysql获取当天用户生日

一、mysql 日期函数

1、day('Y-m-y')						返回日期值

2、month('Y-m-y')					返回月份值

3、year('Y-m-y')					返回年份值

4、now()							返回当前年月日


二、思路

	（生日）月-日=（当前）月-日

// 写法1 只匹配月和日
$birthday_arr = "SELECT * FROM `t_user` WHERE (month(`birthday`) = month(now()) AND day(`birthday`) = day(now()))";

// 写法2 
$birthday_arr = "SELECT * FROM `wx_member` where DATE_FORMAT(`birthday`,'%m-%d') = DATE_FORMAT(NOW(), '%m-%d')";

// PHP TP3写法
$birthday_arr = M('User')
			->where('month(`birthday`) = month(now()) AND day(`birthday`) = day(now())')
			->select();

// PHP TP5写法
$birthday_arr = Db::name('user')
			->whereRaw('month(`birthday`) = month(now()) AND day(`birthday`) = day(now())')
			->select();