/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

6 votes120 views1 answer
Oracle desc table primary key
SQL
0 vote109 views2 answers
SQL Server Standard
SQL
0 vote130 views1 answer
Drop table BigQuery table columns
SQL
2 votes126 views1 answer
Add new column not null sql server
SQL
0 vote106 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote114 views1 answer
Sql get count without group by
SQL
1 vote117 views1 answer
Oracle drop temporary table
SQL
0 vote131 views1 answer
Cannot start database server xampp mac os
SQL
7 votes121 views1 answer
Buy forge mods server hosting
SQL
2 votes156 views1 answer
Creating a view SQL
SQL