/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 vote152 views1 answer
Count in sql and diff
SQL
1 vote132 views1 answer
Get table column names sql ssms
SQL
6 votes154 views2 answers
Postgresql pg_dump
SQL
0 vote136 views2 answers
Psql commande \gset
SQL
0 vote139 views1 answer
Sql server select ignore dupplicates
SQL
1 vote139 views1 answer
Sql order by where condition
SQL
1 vote154 views1 answer
Mysql not supported auth mode
SQL
0 vote133 views1 answer
Monthly Birthday SQL Query
SQL
0 vote131 views1 answer
Backup a table in sql
SQL
0 vote96 views2 answers
Sql query unique
SQL