/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

15 votes306 views2 answers
Open postgress in terminal mac
SQL
0 vote314 views1 answer
Oracle shrink table
SQL
0 vote311 views1 answer
Call rest api from postgresql
SQL
2 votes338 views1 answer
Q operator in oracle
SQL
0 vote308 views1 answer
First Step in installing SQL workbench
SQL
0 vote339 views1 answer
Oracle to_number
SQL
6 votes309 views5 answers
Mysql get last insert id
SQL
0 vote334 views1 answer
Mql5 datetime get hour
SQL
1 vote303 views1 answer
Mysql get character set
SQL
2 votes287 views1 answer
Mysql auto increment jumping
SQL