A表的id字段是以'1,2,3,4,5'...这样的形式存的，它关联字典表B的id字段，此时需求是要查出name
SQL：
SELECT
a.id,
(
SELECT
GROUP_CONCAT(t.NAME)
FROM
test t
WHERE
FIND_IN_SET(
t.id,
a.fixedAssetClass
)
)name
FROM
table a
WHERE
a.id = '123'
还有一种情况会用到循环。
SQL：
SELECT
a.*
FROM table a
........
where a.id in
<foreach collection="arr" item="item" index="index"
open="(" separator="," close=")">#{item}</foreach>
GROUP BY a.id
转载请注明原文地址: https://ju.6miu.com/read-669112.html
