Conditional ORDER BY

Discussion in 'MySQL' started by lektrikpuke, May 31, 2015.

0
  1. #1
    select blah, blah, blah
    order by
    fldRecur
    , case fldRecur
    when 1 then fld_order_timestamp
    when 0 then fldCreateTimeStamp
    end;

    The above works, however what I really want is fld_order_timestamp desc and fldCreateTimeStamp asc. I cannot seem to make that part work. Help?
     
    lektrikpuke, May 31, 2015 IP
  2. lektrikpuke

    lektrikpuke Well-Known Member

    Messages:
    297
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    113
    #2
    got it!

    order by
    fldRecur
    , case fldRecur when 1 then fld_order_timestamp end desc
    , case fldRecur when 0 then fldCreateTimeStamp end asc
     
    lektrikpuke, Jun 1, 2015 IP