HOW TO select posts and order by multiple custom fields concat ? (1 post)

  1. MPI
    Posted 5 years ago #

    Hi everyone,

    Resume ---------
    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 ?

Topic Closed

This topic has been closed to new replies.

About this Topic