mysql - 如何在mysql中按要求的顺序检索行

Question

我有如下表格，

表 1

当我使用查询时

“SELECT cat_title FROM table1 WHERE cat_id IN(21,10,25,4)”

结果按顺序

cat_title

Bank

Beauty Parlour

Car

Accomodation

但我需要查询中给出的结果，例如

cat_title

Car

Beaty Parlour

Accomodation

Bank

我要做什么？

Answer 1

你可以试试这个:

SELECT cat_title
FROM table1
WHERE cat_id IN(21,10,25,4)
ORDER BY (cat_id = 21) DESC, (cat_id = 10) DESC, (cat_id = 25) DESC, (cat_id = 4) DESC;

或

SELECT cat_title
FROM table1
WHERE cat_id IN(21,10,25,4)
ORDER BY FIND_IN_SET(cat_id, ('21,10,25,4'));