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.
look at:
http://www.mysql.com/doc/en/String_functions.html
John Coder
---------------------------------------------------------------------
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
