sutejok
asked on
birthdate from mysql?
Hi,
my table has a field called birthdate, with type date. the data are stored in the form of yyyy-mm-dd
how do i select from my database, list of birthdates, sorted from the most upcoming one?
i.e. how do i select from mysql such that the "WHERE" condition is only comparing the month and date?
"SELECT * FROM user WHERE birthdate< ????????? order by ??????? "
thx
my table has a field called birthdate, with type date. the data are stored in the form of yyyy-mm-dd
how do i select from my database, list of birthdates, sorted from the most upcoming one?
i.e. how do i select from mysql such that the "WHERE" condition is only comparing the month and date?
"SELECT * FROM user WHERE birthdate< ????????? order by ??????? "
thx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER