/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 vote357 views1 answer
Create table sql generator
SQL
2 votes372 views1 answer
How to get non distinct values in sql
SQL
0 vote403 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote369 views1 answer
SQL Server rename foreign key constraint
SQL
1 vote441 views2 answers
Copy table in sql
SQL
0 vote361 views1 answer
Setval in postgres
SQL
1 vote377 views1 answer
Print year of a date sql
SQL
0 vote349 views1 answer
Price-colour
SQL
1 vote367 views1 answer
Oracle repeat_interval 5 minutes
SQL
1 vote411 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL