List:General Discussion« Previous MessageNext Message »
From:Pag Date:December 28 2002 2:51am
Subject:ORDER dilemma
View as plain text  
	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


Thread
style question: "drop database" in an install scriptDavid T-G28 Dec
  • ORDER dilemmaPag28 Dec
    • RE: ORDER dilemmaJohn Coder28 Dec
      • Re: ORDER dilemmaDan Nelson28 Dec
  • Re: style question: "drop database" in an install scriptiConnect \(Berlin\) Stefan Hinz28 Dec
  • RE: style question: "drop database" in an install scriptArthur Fuller30 Dec
    • Re: style question: "drop database" in an install scriptDavid T-G30 Dec
Re: style question: "drop database" in an install scriptDavid T-G28 Dec