如何通过动态方式转换订单

Question

我试图用条件if 来订购这个sql

FROM sgm_whatsapp
WHERE `phone_number` = '51996268989' 
IF(delivery_date > answer_date, ORDER BY delivery_date DESC, ORDER BY answer_date DESC);

它不起作用。有人能帮我吗？

Answer 1

通过IF 订购

FROM sgm_whatsapp
WHERE `phone_number` = '51996268989' 
order by       
IF(delivery_date > answer_date, delivery_date , answer_date) desc;

Answer 2

SELECT fields
FROM sgm_whatsapp
WHERE `phone_number` = '51996268989' 
ORDER BY
CASE WHEN delivery_date > answer_date THEN delivery_date
ELSE answer_date 
END DESC