/SQL/Mysql join table with a text columns with ids splited by char

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

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

Source: stackoverflow.com

Similar codes

25 votes210 views6 answers
How to change column name in mysql
SQL
0 vote230 views1 answer
Cartesian product sql
SQL
25 votes211 views4 answers
Metadata
SQL
0 vote189 views1 answer
Move table to a different schema
SQL
0 vote211 views1 answer
Carbon mysql d m y to y-m-d
SQL
1 vote205 views5 answers
What is in operator in sql
SQL
19 votes185 views6 answers
Laravel sql query
SQL
13 votes241 views6 answers
Mysql remove duplicates
SQL
0 vote177 views1 answer
Csv to sqlite python
SQL
10 votes190 views2 answers
Mysql drop database if exists
SQL