The simple answer might be:
SELECT member.*
FROM `member`
WHERE DAYOFYEAR(member_dob) = DAYOFYEAR(CURDATE())
ORDER BY member_dob DESC LIMIT 1
Seems to work for me. The problem is that it wouldn't support members that
have a birthday on the same day :) To solve that I would select the next
On Fri, 8 Mar 2002, Robert V. Zwink wrote:
The simple answer might be:
SELECT member.*
FROM `member`
WHERE DAYOFYEAR(member_dob) = DAYOFYEAR(CURDATE())
ORDER BY member_dob DESC LIMIT 1
Seems to work for me.
Not for me. I think it should be ordered like this:
ORDER BY