mysql使用in查询时，根据in语句中的顺序进行排序

princeAladdin

于 2022-08-12 16:21:02 发布

阅读量1k

点赞数

文章标签： sql 数据库

本文链接：https://blog.youkuaiyun.com/weixin_45817985/article/details/126306603

版权

mysql使用in查询时，根据in语句中的顺序进行排序

SELECT a.*,b.rwid,b.gzdw,b.xrzw FROM \n" +
            "(SELECT * FROM \"basic\" where delete_mark=0 and id in   <foreach item=\"item\" index=\"index\" collection=\"list\"  open=\"(\" separator=\",\" close=\")\">\n" +
            "            #{item} </foreach>                 limit ${limit}\n" +
            ") AS a LEFT JOIN (SELECT * FROM \"duty\" where delete_mark=0 and rwid in   <foreach item=\"item\" index=\"index\" collection=\"list\"  open=\"(\" separator=\",\" close=\")\">\n" +
            "            #{item} </foreach>)AS b ON a.id=b.rwid  where a.id is not null  ORDER BY <foreach collection=\"list\" item=\"styleNumId\" separator=\",\" open=\"(a.id,\" close=\")\"> \n" +
            "      #{styleNumId} \n" +
            "    </foreach>  desc