/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

1 vote301 views1 answer
Postgresql delete cascade
SQL
3 votes308 views2 answers
Mysql import gz
SQL
0 vote338 views1 answer
Select the date 30 days less that the todays date sql request
SQL
4 votes314 views2 answers
Truncate oracle
SQL
0 vote318 views1 answer
Generate random & unique mysql string
SQL
16 votes311 views6 answers
Install sqlite3 python
SQL
0 vote315 views1 answer
Mysql extract day from date leading zero
SQL
1 vote296 views1 answer
Adding a check statement in sql
SQL
0 vote302 views1 answer
Set classpath for mysql-connector.jar
SQL
6 votes276 views1 answer
Phpmyadmin reset root password
SQL