MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


10.3.32-MariaDB


create table t (workerid int, worktype varchar(20));

Insert into t values(7, 'management');
Insert into t values(7, 'cleaning');
Insert into t values(7, 'cooking');
Insert into t values(2, 'cleaning');
Insert into t values(4, 'management');
Insert into t values(4, 'cooking');
select * from t


workerid
worktype


7
management

7
cleaning

7
cooking

2
cleaning

4
management

4
cooking


select workerid, GROUP_CONCAT(worktype)
from t
group by workerid


workerid
GROUP_CONCAT(worktype)


2
cleaning

4
management,cooking

7
management,cleaning,cooking