SQLite:以手动顺序选择多个ID [英] SQLite: select multiple ids with manual order

问题描述

我想按我的顺序选择多个ID.例如:

I want to select multiple Ids but in my order. for example:

SELECT * FROM mytable WHERE id IN (3,1,4)

我希望订单为: 3 1个 4 与我的查询相同.

I want the order to be: 3 1 4 same as my query.

有什么主意吗?

推荐答案

您可以在订单中使用case语句.

You can use a case statement for your order by.

SELECT * FROM mytable WHERE id IN (3,1,4)
ORDER BY 
CASE 
WHEN id = 3 THEN 1
WHEN id = 1 THEN 2
WHEN id = 4 THEN 3
END

这篇关于SQLite:以手动顺序选择多个ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！