myqsl 语句 select * from test where JSON_CONTAINS(a.department, JSON_OBJECT('id', 1234))
利用 Specification 如何拼接查询条件?
表头 | 表头 |
---|---|
id | department |
1 | [{"id": 1233, "departmentName": "财务部"}, {"id": 1234, "departmentName": "市场"}] |
myqsl 语句 select * from test where JSON_CONTAINS(a.department, JSON_OBJECT('id', 1234))
利用 Specification 如何拼接查询条件?
表头 | 表头 |
---|---|
id | department |
1 | [{"id": 1233, "departmentName": "财务部"}, {"id": 1234, "departmentName": "市场"}] |