ORDER dilemma

[Pag]

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

How can i do such a thing?

Thanks.


Pag



---------------------------------------------------------------------
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