mysql join table with a text columns with ids splited by char

Banana answered on December 13, 2021 Popularity 1/10 Helpfulness 1/10

answer mysql join table with a text columns with ids splited by char

mysql join table with a text columns with ids splited by char

Comment

SELECT a.c1,
        a.ids,
        GROUP_CONCAT(b.name SEPARATOR '|')
FROM Table1 a
INNER JOIN Table2 b
ON FIND_IN_SET(b.id, REPLACE(a.ids, '|', ','))
GROUP BY a.c1,
        a.ids

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: char ids join mysql sql text

Link to this answer
Share Copy Link

Contributed on Dec 13 2021

Banana

0 Answers Avg Quality 2/10

mysql join table with a text columns with ids splited by char

Contents

More Related Answers

mysql join table with a text columns with ids splited by char

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.