On 3 Apr, 11:41, "roohbir" <com> wrote:
Well, since current_date + 10 years is in the future, anyone who has
already been born satisfies that condition!
The query below assumes that "in the next week", includes today.
WHERE `dob` > CURRENT_DATE - INTERVAL 10 YEAR
AND `dob` BETWEEN CURRENT_DATE AND CURRENT_DATE + INTERVAL 7 DAY