/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 vote500 views1 answer
Sql insert exemplo
SQL
3 votes358 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote353 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote356 views1 answer
Call function sql oracle with output put line
SQL
0 vote359 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote335 views1 answer
Sql remove last x char
SQL
0 vote362 views1 answer
Sql last time database was accessed
SQL
0 vote350 views1 answer
Restore backupfile discourse
SQL
1 vote405 views1 answer
Sql count value greater than
SQL
2 votes356 views1 answer
SQL column name Postgre
SQL