I want to have a liste of posts sort by begin date, this data is memory into 3 custom fields.
How to in a SELECT Sql query or other technique in wordpress class
ORDERBY a CONCAT of multiple Custom Fields ???
In detail ---------
I have posts with 3 custom fields like :
begindate_day (numeric data up 01 to 31)
begindate_month (numeric data up 01 to 12)
begindate_year (numeric data up 2009 to 2012)
i need to concat them to have a numeric string like :
i want to use a query and sort by begin date (20100415 for now 15/04/2010 )
all of these in only query, how to do ?