-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Works perfectly! Thanks!
Roger Baklund wrote: | Yes, it can be done using the FIELD() function: | | SELECT * FROM tablename | ORDER BY | MID(datecol,8), # year | FIELD(LEFT(datecol,3), # month | 'Jan','Feb','Mar','Apr','May','Jun', | 'Jul','Aug','Sep','Oct','Nov','Dec'), | MID(datecol,5,2); # day | | <URL: http://www.mysql.com/doc/en/String_functions.html#IDX1185 > |
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAEABdIcIs3CP5DxwRAl8rAJ91Di2n0/n/uuSBSAm0dJle+GIXUACdENd2 C8NmS3Ft2iIlrad6BRFA7wE= =kVtA -----END PGP SIGNATURE-----
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
