/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

0 vote206 views1 answer
Inserted row count tsql
SQL
0 vote199 views1 answer
Get who is hired in specific month in sql
SQL
2 votes206 views2 answers
How to view created temporary tables in mysql
SQL
0 vote207 views1 answer
Fast sql column count
SQL
9 votes217 views4 answers
Postgresql export database
SQL
15 votes212 views3 answers
Find duplicate keys in mysql
SQL
0 vote196 views1 answer
How to define a save method in ruby for sql databases
SQL
0 vote209 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
5 votes214 views4 answers
Upload database mysql command line
SQL
0 vote191 views1 answer
Oracle job class
SQL