I am trying to fins 'upcoming birthdays' of the users present in the Database.
I can able to fine the users upcoming birthday only till 12 month (Dec).
What if I need to find the upcoming birthday of next year.
My Query:
SELECT c.F_CONTACT_ID,
c.F_CONTACT_NAME,
c.F_CONTACT_FNAME,
DATE_FORMAT(c.F_DOB, '%d/%m') F_DOB
FROM t_contact c
WHERE DATE_FORMAT(F_DOB, '%m') >= '08'
GROUP BY c.F_CONTACT_ID
ORDER BY c.F_DOB ASC LIMIT 0 ,
10
How can I find the upcoming birthday of the users who born on 'January' because the
DATE_FORMAT(F_DOB, '%m') >= '08'
can able to check till 12th month.
Can some one help me?