使用子查询选择ID列表并加入它：
select t1.*from t1inner join( select 1 as id, 1 as num union all select 5, 2 union all select 3, 3) ids on t1.id = ids.idorder by ids.num
UPD： 固定代码
使用子查询选择ID列表并加入它：
select t1.*from t1inner join( select 1 as id, 1 as num union all select 5, 2 union all select 3, 3) ids on t1.id = ids.idorder by ids.num
UPD： 固定代码
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
