In the last episode (Dec 27), John Coder said:
>
>
> Hi all,
>
> I am kinda of a beginner in this mysql thing, so please excuse the dumb
> and amateur question:
>
> i have a table with several date fields: day, month, year, hour, minute
> and i need to order them by a specific "string that includes them, like
> this:
>
> "year/month/day - hour/minute"
>
> basically i need some select command like this:
>
> SELECT * FROM NEWS ORDER BY "year/month/day - hour/minute" DESC LIMIT 10
ORDER BY year,month,day,hour,minute
--
Dan Nelson
[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
