/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 vote153 views2 answers
Oracle chain rules
SQL
1 vote153 views3 answers
Mysql disable foreign keys check
SQL
2 votes168 views2 answers
Storing timezones in postgres
SQL
0 vote156 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote173 views1 answer
How to fetch data from database in sql
SQL
0 vote155 views1 answer
Basic structure of sql expression having clause
SQL
1 vote150 views1 answer
Convert rows to string sql server
SQL
1 vote170 views1 answer
Minus vs intersect in sql
SQL
6 votes161 views2 answers
Sql display max value
SQL
0 vote142 views1 answer
Sql developer export connections
SQL