常见查询

SELECT * FROM tb_user WHERE id IN (5, 1) ORDER BY FIELD(id, 5, 1); 会根据 idStr 中指定的顺序对结果进行排序

List<Long> ids = set.stream()
                .map(Long::valueOf)
                .collect(Collectors.toList());
String idStr = StrUtil.join(",", ids); // ex: 5,1
List<User> user = userService.query().in("id", ids)
                .last("ORDER BY FIELD(id," + idStr + ")").list();

SELECT user_id FROM tb_blog WHERE (create_time < '2024-10-17') GROUP BY user_id;

// lt < ,gt >
List<Blog> list = blogService.list(new QueryWrapper<Blog>()
          .select("user_id")
          .lt("create_time", "2024-10-17")
          .groupBy("user_id");
);

---

Be the first one to support oldfesixsixsix.

---