/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 vote290 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote301 views1 answer
SQL check if record exist
SQL
0 vote255 views1 answer
Provera dupliranih konatakata
SQL
4 votes263 views1 answer
To date oracle with time
SQL
0 vote286 views1 answer
Postgresql combine values in one field
SQL
-1 vote290 views1 answer
How to change the auto increment in existing table mysql
SQL
1 vote281 views1 answer
Sysdate in sql
SQL
14 votes300 views2 answers
Oracle add attribute to table
SQL
3 votes292 views3 answers
Stop mysql ubuntu
SQL
3 votes314 views4 answers
Postgresql change timezone on timestamp without timezone
SQL