主页 / 问题 / 1091420
Accepted
Владислав Самохин
Asked:2020-03-06 16:39:59 +0000 UTC2020-03-06 16:39:59 +0000 UTC

如果条件按mysql排序

  • 772

请告诉我有一张桌子：

id|user_with|user_creator|fav_user_with|fav_user_creator|
1 |   10    |     15     |      1      |        0       |
2 |   10    |     15     |      0      |        1       |
3 |   15    |     10     |      0      |        1       |
4 |   15    |     10     |      1      |        0       |
5 |   15    |     10     |      0      |        1       |

我该怎么做排序。

如果user_creator = 15然后。fav_user_creator = 1_order by fav_user_creator desc, id desc

如果user_with = 15然后。fav_user_with = 1_order by fav_user_with desc, id desc

它应该在第一个条件下工作：

id|user_with|user_creator|fav_user_with|fav_user_creator|
2 |   10    |     15     |      0      |        1       |
5 |   15    |     10     |      0      |        1       |
4 |   15    |     10     |      1      |        0       |
3 |   15    |     10     |      0      |        1       |
1 |   10    |     15     |      1      |        0       |

它应该在第二种情况下工作：

id|user_with|user_creator|fav_user_with|fav_user_creator|
4 |   15    |     10     |      1      |        0       |
5 |   15    |     10     |      0      |        1       |
3 |   15    |     10     |      0      |        1       |
2 |   10    |     15     |      1      |        0       |
1 |   10    |     15     |      0      |        1       |
mysql

1 个回答

  1. Best Answer
    …
ORDER BY
  CASE
    WHEN user_creator = 15 AND fav_user_creator = 1 THEN fav_user_creator
    WHEN user_with = 15 AND fav_user_with = 1 THEN fav_user_with 
  END desc,
  id desc
    • 1

相关问题