/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

2 votes105 views2 answers
Sqlalchemy filter or
SQL
1 vote132 views4 answers
How to check table in postgresql from terminal
SQL
3 votes101 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
1 vote112 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote111 views1 answer
Mysql update privileges
SQL
0 vote111 views1 answer
Mysql query single row
SQL
4 votes109 views1 answer
To date oracle with time
SQL
21 votes112 views3 answers
Sql server search column name in all tables
SQL
0 vote106 views2 answers
Get all index postgres
SQL
2 votes101 views4 answers
Duplicate record mysql
SQL