/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

7 votes231 views3 answers
Sql get last inserted row
SQL
5 votes215 views1 answer
List foreign key oracle
SQL
0 vote236 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
10 votes244 views4 answers
How to alter table name in mysql
SQL
0 vote214 views1 answer
Postgresql newline character
SQL
0 vote259 views1 answer
Sql multiple into
SQL
15 votes238 views3 answers
Find duplicate keys in mysql
SQL
0 vote237 views1 answer
Oracle shrink table
SQL
0 vote228 views1 answer
Version and edition of SQL Server Database Engine
SQL
2 votes227 views1 answer
Pandas to sql index
SQL