/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

0 vote310 views1 answer
Systems sql
SQL
1 vote310 views1 answer
Rails run native ssql query
SQL
3 votes324 views1 answer
Sql add two values together
SQL
0 vote358 views1 answer
Mysql concatenate select results
SQL
0 vote291 views2 answers
Database owner can't create new tables postgres
SQL
0 vote291 views2 answers
Mysql to python pandas
SQL
0 vote306 views1 answer
Mysql export and import
SQL
6 votes317 views3 answers
Oracle all dates between two dates
SQL
2 votes308 views1 answer
Tsql copy table
SQL
0 vote331 views1 answer
Oracle to_number
SQL