HOW TO select posts and order by multiple custom fields concat ?

  • mpi

    (@mpi)


    14 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 :
    20100415

    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 ?

  • The topic ‘HOW TO select posts and order by multiple custom fields concat ?’ is closed to new replies.