Order buy like un laiku

[Wuu]

order by case
                when t1.title like "%'.$packet.'%" then 1
                when t1.description like "%'.$packet.'%" then 2
                when t2.post like "%'.$packet.'%" then 3
            end

order by case
                when t1.title like "%'.$packet.'%" && t1.start_date desc then 1
                when t1.description like "%'.$packet.'%" then 2
                when t2.post like "%'.$packet.'%" then 3
            end

Būtībā, kā sakārtot pēc like un timestampa vienlaicīgi.

[l27]

order by case

when t1.title like "%'.$packet.'%" then 1

when t1.description like "%'.$packet.'%" then 2

when t2.post like "%'.$packet.'%" then 3

end,

t1.start_date desc

[Wuu]

Paldies!