/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 vote170 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote228 views1 answer
Mysql default uuid
SQL
2 votes174 views1 answer
No data found oracle
SQL
0 vote179 views1 answer
Adding generated time in row mysql workbench
SQL
1 vote187 views1 answer
Tsql replace value in json
SQL
0 vote183 views1 answer
Sql server size of every table in a db
SQL
0 vote279 views1 answer
How to update random rows in sql
SQL
1 vote184 views1 answer
Mysql order by desc null last
SQL
0 vote174 views1 answer
Login failed for login due to trigger execution
SQL
0 vote167 views1 answer
Gcloud check sql
SQL