/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

13 votes315 views2 answers
Sqlite rename column
SQL
0 vote333 views2 answers
SQL BULK INSERT
SQL
2 votes354 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
2 votes320 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote324 views1 answer
Sqlalchemy query return only n results
SQL
5 votes339 views1 answer
Oracle generate list of dates in between a date range
SQL
3 votes354 views1 answer
Sql add two values together
SQL
1 vote329 views1 answer
Sqlite3 read only
SQL
0 vote348 views1 answer
Sql query tags
SQL
23 votes352 views3 answers
Sql where contains part of string
SQL