I have a table with a date field, and would like to sort it
on month and day. What I would like to do is:
SELECT lastname,firstname,dob FROM table1 GROUP BY month(dob),day(dob)
(where dob is a column of type 'date')
but that doesn't work. I'm using MySQL 3.22.32. I saw one post about
calculated fields, but that method didn't seem to work for me either.
>From some other posts, it appears like I will have to resort to a temporary
table. Is this correct? Am I missing something simple?
Thanks,
-- Ralph
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
