linshimingyi
commented
2 years ago 请问 怎么使用多表关联时的多字段模糊查询呢？ 比如，select a.* from a left join b on a.id = b.a_id left join c on a.id = c._a_id where b.name = ? and c.status = ? 这样一个sql，应该怎么实现呢？感谢
Closed elunez closed 2 years ago
linshimingyi
commented
2 years ago 请问 怎么使用多表关联时的多字段模糊查询呢？ 比如，select a.* from a left join b on a.id = b.a_id left join c on a.id = c._a_id where b.name = ? and c.status = ? 这样一个sql，应该怎么实现呢？感谢
elunez
commented
2 years ago @linshimingyi
请问 怎么使用多表关联时的多字段模糊查询呢？ 比如，select a.* from a left join b on a.id = b.a_id left join c on a.id = c._a_id where b.name = ? and c.status = ? 这样一个sql，应该怎么实现呢？感谢
@Query(joinName = "", propName="", join = Query.Join.RIGHT)
// 指定type为模糊查询就行 type = Query.Type.
https://el-admin.vip/pages/010203/