/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

10 votes174 views2 answers
Show tables in schema oracle
SQL
0 vote193 views1 answer
Transaction and commit trong sql server
SQL
1 vote177 views1 answer
Where not in array sql
SQL
2 votes157 views1 answer
Sqlplus clear screen
SQL
1 vote135 views1 answer
Convert money to varchar sql server
SQL
0 vote168 views1 answer
Typeorm raw sql
SQL
7 votes185 views5 answers
Max 3 salary in sql
SQL
0 vote178 views1 answer
Mysql regex exact match
SQL
0 vote119 views2 answers
Denormalization in sql
SQL
13 votes159 views2 answers
Mysql order by multiple columns
SQL