> That's perfect, but in DESC mode, it orders like this:
> Sep 28, 2003
> Oct 05, 2003
> Dec 31, 2003
> Dec 06, 2003
> Jan 14, 2004
> Jan 10, 2004
> Jan 02, 2004
If you're ordering by three fields and you want all of them to be in
descending order you have to put "DESC" after each of them, not just
the last one.
ORDER BY
MID(datecol,8) DESC,
FIELD(LEFT(datecol,3),
'Jan','Feb','Mar','Apr','May','Jun',
'Jul','Aug','Sep','Oct','Nov','Dec') DESC,
MID(datecol,5,2) DESC
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
