/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 vote244 views1 answer
Sql server datetime
SQL
-1 vote221 views1 answer
Mysql change database charset and collation
SQL
0 vote201 views1 answer
Downgrading sql localdb visual studio
SQL
1 vote207 views1 answer
Mysql select another database
SQL
0 vote359 views2 answers
Create fulltext index mysql
SQL
2 votes202 views4 answers
Check timezone of mysql database
SQL
0 vote222 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
4 votes190 views1 answer
Id primary key auto generated
SQL
0 vote225 views1 answer
To Create directory
SQL
6 votes279 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL