我的桌子是这些：
员工表：
+-----------+----------+------------+
| id | name | department |
+-----------+----------+------------+
| 1 | Carrera | 1 |
| 2 | Taylor | 1,2 |
+-----------+----------+------------+
部门表：
+--------+-------+
| id | name |
+--------+-------+
| 1 | CS |
| 2 | IT |
+--------+-------+
想要从员工表和部门表输出：
+----+------------+-------------+
| id | name | department |
+----+------------+-------------+
| 1 | Carrera | CS |
| 2 | Taylor | CS,IT |
+----+------------+-------------+
您应该避免将数据存储为逗号分隔值，并遵循规范化。
但是在这种情况下你可以做一些事情
select
e.id ,
e.name ,
group_concat(d.name) from employee e
left join department d on find_in_set(d.id,e.department)
group by e.id ;
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
