Mysql 使用 in 查询，如何保证查出来顺序与传入的条件顺序保持一致?

Northofnanshan

已于 2023-02-14 11:24:44 修改

阅读量481

点赞数

文章标签： mysql java 数据库 Powered by 金山文档

于 2023-02-14 11:10:37 首次发布

本文链接：https://blog.csdn.net/Northofnanshan/article/details/129023463

版权

  <where>
            ((s.BUSINESS_SEQ ='1' OR s.BUSINESS_SEQ IS NULL) and (a.BUSINESS_SEQ='1' OR a.BUSINESS_SEQ IS NULL))
            <choose>
                <when test="ids != null and ids.size()>0">
                    <foreach collection="ids" item="id" index="index" open="AND p.id in (" close=")" separator=",">
                        #{id}
                    </foreach>
                </when>
                <otherwise>
                    AND p.id = 'jgiehggiehgiehgiegiehhghiehggiheghheuih'
                </otherwise>
            </choose>
            <if test="ids != null ">
                order by FIELD(p.id,
                <foreach collection="ids" item="item" separator=",">
                    #{item}
                </foreach>
                )
            </if>
        </where>


//传入参数ids
<when test="ids != null and ids.size()>0">
                    <foreach collection="ids" item="id" index="index" open="AND p.id in (" close=")" separator=",">
                        #{id}
                    </foreach>
                </when>
//按传入参数ids进行排序
ORDER BY FIELD(id,
    <foreach collection="list" item="item" separator=",">
      #{item}
    </foreach>