如何从数据库获取今天生日的人的详细信息？

Question

I have the below query which gets details of people selected according to the month in my php project.So it displays me the list of people who have birthdays on this month. But I really want is to get the list of people who have birthdays on today. Please help me to change this query...

select * from customer_info
  where date_format(str_to_date(b_day, '%Y-%m-%d'), '%m') = MONTH(NOW()); 

Answer 1

How about just using month() and day()?

select ci.*
from customer_info ci
where month(b_day) = month(curdate()) and day(b_dat) = day(curdate());