From: Peter Hicks
Date: April 26 1999 10:50pm
Subject: Order by date
List-Archive: http://lists.mysql.com/mysql/2424
Message-Id: <E10buCj-0001E9-00@relay5.ftech.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7BIT

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Folks,

I have the following SQL statement:

   SELECT * FROM members WHERE date_of_birth != '0000-00-
00' ORDER BY date_of_birth;

date_of_birth is a DATE field, and I want to sort the results of the 
query on the month and day - to extract a list of birthdays 
throughout the year, in order, ignoring the year of birth.

Can anyone help?



-----BEGIN PGP SIGNATURE-----
Version: PGP 6.0.2 -- QDPGP 2.60 

iQA/AwUBNyTtxyNeTDpbBy8EEQLq5QCgh9XgBG2YKLxWK3gH/VHWE+2OeYgAoK7Z
DAjOFM6kkRywE53CqBxP6KPF
=xu+x
-----END PGP SIGNATURE-----

---
Peter Hicks
Network Engineer
peter <DOT> hicks (AT) poggs.co.uk