How can i turn order by dynamic?

Question

I have tried to order this sql with a conditional if

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

It isn't working. Can someone help me?

you can use sql `case` check [this](https://stackoverflow.com/a/7464492/3864485) — Faesal, Dec 06 '21 at 20:36
Does this answer your question? [Can you add an if statement in ORDER BY?](https://stackoverflow.com/questions/3550942/can-you-add-an-if-statement-in-order-by) — RoMEoMusTDiE, Dec 06 '21 at 20:38
Take consideration that in this situation, as explained in the referer answer, CASE is better choice than IF function — Leandro Bardelli, Dec 06 '21 at 21:31
For future reference, "it isn't working" isn't a helpful problem description — HoneyBadger, Dec 06 '21 at 21:33

score 1 · Answer 1 · answered Dec 06 '21 at 20:36

1

Order by IF

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

answered Dec 06 '21 at 20:36

RoMEoMusTDiE

4,739
1
17
26

Worked. thank you – bBraian Dec 06 '21 at 20:47

score 1 · Answer 2 · answered Dec 06 '21 at 20:37

1

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

answered Dec 06 '21 at 20:37

Leandro Bardelli

10,561
15
79
116

How can i turn order by dynamic?

2 Answers2