• 基地表中的产品ids
    image
  • 产品表
    image-1673257505158
  • sql写法
SELECT
a.farm_name,a.address,a.person_phone,GROUP_CONCAT(b.product_name SEPARATOR ',') as productNames
FROM
trace_base a
LEFT JOIN trace_product b ON FIND_IN_SET(b.id,a.products)
WHERE
a.tenant_id=2020010602
GROUP BY a.farm_name,a.address,a.person_phone

结果：
image-1673258030869