/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 votes158 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote287 views1 answer
Dublicate row sql
SQL
0 vote144 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote85 views1 answer
Mysql convert column to uppercase
SQL
1 vote130 views3 answers
Postgresql connect to database
SQL
0 vote141 views1 answer
Ver usuarios mysql
SQL
-1 vote84 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote126 views10 answers
Sql statement checker corrector
SQL
11 votes136 views2 answers
Having in sql
SQL
0 vote136 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL