/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 vote256 views1 answer
Ora 00001 error catch plsql
SQL
0 vote261 views1 answer
Console output pl sql
SQL
4 votes339 views2 answers
Delete all table oracle
SQL
17 votes255 views4 answers
Set mysql Password
SQL
0 vote267 views1 answer
Select even number id data from table
SQL
1 vote263 views2 answers
Mysql show views
SQL
1 vote262 views1 answer
Get table which have specific columns in mysql
SQL
0 vote256 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote266 views1 answer
Restart sql server command line linux
SQL
11 votes292 views2 answers
Having clause in sql
SQL