/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

3 votes134 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote147 views1 answer
Sql server phone constraint
SQL
0 vote136 views1 answer
Sql delimiter to columns
SQL
0 vote141 views1 answer
Sql server python connection
SQL
5 votes145 views2 answers
Mysql where in array
SQL
0 vote136 views1 answer
Soql user profile
SQL
0 vote140 views1 answer
Query builder doctrien return sql
SQL
21 votes122 views1 answer
Cheatsheet for sql
SQL
0 vote131 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote132 views1 answer
Python list from sql
SQL