当使用CASE WHEN时，如何在Laravel中使用order by? [英] How to use order by in Laravel when it uses CASE WHEN?

问题描述

我可以像这样在Laravel中使用 orderBy 方法:

I can use orderBy method in Laravel like this:

$posts = Post::orderBy('id', 'DESC')->get();

好吧，如果 ORDER BY 子句中有 CASE ，该怎么办?像这样:

Ok, what about when there is CASE in the ORDER BY clause? Like this:

ORDER BY 
CASE
   WHEN id.PinRequestCount <> 0 THEN 5
   WHEN id.HighCallAlertCount <> 0 THEN 4
   WHEN id.HighAlertCount <> 0 THEN 3
   WHEN id.MediumCallAlertCount <> 0 THEN 2
   WHEN id.MediumAlertCount <> 0 THEN 1
END desc,

如何在Laravel中写这个^?

How can I write this ^ in Laravel?

推荐答案

尝试一下:

->orderByRaw(
     "CASE WHEN <CONDITION> THEN < > ELSE < > END DESC"
)

这篇关于当使用CASE WHEN时，如何在Laravel中使用order by?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！