/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

4 votes220 views3 answers
Mysql modify foreign key
SQL
2 votes208 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote223 views1 answer
Mysql cast null to string
SQL
0 vote286 views1 answer
Sql select max value for each group
SQL
0 vote213 views1 answer
WHERE not regex in SQL
SQL
0 vote239 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote202 views1 answer
ORA-13717
SQL
0 vote161 views1 answer
Big query add table rows to another table
SQL
0 vote255 views1 answer
Set Mamp mysql globally
SQL
-1 vote234 views2 answers
Sql truncate number
SQL