From: Dan Nelson
Date: December 28 2002 4:06am
Subject: Re: ORDER dilemma
List-Archive: http://lists.mysql.com/mysql/128521
Message-Id: <20021228040632.GA86291@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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
	dnelson@stripped