RE: ORDER dilemma

[John Coder]

	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