mysql - 根据潜在客户的 ID 将所有注释连接在一行中？

Question

我有一个查询，要查找 sugarcrm 中某个线索的所有注释。根据屏幕截图，潜在客户有 3 或 4 个注释。

我想根据潜在客户的 ID 将所有注释连接到一行(名称列)中。

我的查询是，

---

SELECT l.first_name, l.last_name, l.id, n.name, n.description
FROM 
    leads AS l inner join notes as n on l.id = n.parent_id
where l.deleted = 0
and n.deleted = 0
and l.id='104c4b25-adab-32f3-16ee-50d098a5dd5d'

---

Answer 1

您可以使用 group_concat()功能

SELECT l.first_name, l.last_name, l.id, group_concat(n.name), n.description
FROM 
    leads AS l inner join notes as n on l.id = n.parent_id
where l.deleted = 0
and n.deleted = 0
and l.id='104c4b25-adab-32f3-16ee-50d098a5dd5d'
group by l.id