select t.*from tb_user t
--排序顺序by id 3 1 4 2 5
select id, name
from tb_user
where id in ('1', '2', '3', '4','5')
order by (case id
when '3' then
'A'
when '1' then
'B'
when '4' then
'C'
when '2' then
'D'
when '5' then
'E'
end)