/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 votes134 views1 answer
Add constraint fk
SQL
3 votes152 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote140 views1 answer
Write SQL in ruby on rails
SQL
0 vote136 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote177 views1 answer
For select oracle
SQL
4 votes269 views1 answer
Oracle table statistics
SQL
5 votes95 views1 answer
Mongodb vs
SQL
0 vote141 views1 answer
Oracle service name view
SQL
0 vote156 views1 answer
Sql out file formate
SQL
0 vote137 views1 answer
Find usage of table in sql server
SQL