<select id="listUserByDeptIds" resultMap="BaseResultMap"> select u.* from t_user u left join t_depart d on d.id = u.u_depart_id where u.u_status = 0 and FIND_IN_SET(u.u_depart_id,#{deptIds}) order by d.order_num,u.u_order </select>
查询多个值-mysql函数FIND_IN_SET
最新推荐文章于 2024-01-04 23:02:04 发布