mysql query for retrieving multiple values as array

Question

I have two tables user and task as follows:

user:

task:

I need to query to get all the user ids of the task id whose user is 2 and the output table should be:

Can anybody help me with the query? Thanks in advance.

id'7238 · Accepted Answer · 2020-12-15 05:17:40Z

2

Use the GROUP_CONCAT function:

SELECT 
    t.task_id AS task_id,
    GROUP_CONCAT(t.user_id) AS user_id,
    GROUP_CONCAT(u.username) AS user
FROM task t
JOIN user u ON t.user_id = u.id
WHERE EXISTS (
   SELECT 1 FROM task
   WHERE task.task_id = t.task_id AND task.user_id = 2
)
GROUP BY t.task_id

edited Dec 15, 2020 at 5:17

answered Dec 15, 2020 at 5:06

id'7238

2,7261 gold badge6 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

geethuth Over a year ago

Thank you so much. It worked as expected.

Collectives™ on Stack Overflow

mysql query for retrieving multiple values as array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related