/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 vote304 views1 answer
How to increase the width of the screen in oracle
SQL
1 vote309 views1 answer
Return size of tables in mysql
SQL
3 votes331 views1 answer
Oracle list user grants
SQL
5 votes351 views1 answer
Mysql add user with all privileges
SQL
1 vote325 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote308 views3 answers
Convert sql query to python pandas
SQL
16 votes328 views1 answer
Mssql int max value
SQL
1 vote299 views1 answer
Postgres get timestamp
SQL
0 vote343 views1 answer
ORA-13717
SQL
0 vote337 views1 answer
Sql get latest of 2 datetimes
SQL