/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

2 votes161 views1 answer
Oracle sql day of month from date
SQL
2 votes202 views2 answers
How to run postgresql in linux
SQL
0 vote196 views1 answer
Postgres - Login and connect as default user
SQL
0 vote122 views1 answer
Check if due date is less than todays date sql
SQL
0 vote188 views1 answer
Database db connection string format
SQL
0 vote154 views1 answer
Select value from previous row in postgresql
SQL
1 vote162 views2 answers
Mysql spring boot application.properties
SQL
0 vote179 views1 answer
Sql alter table order by
SQL
0 vote168 views1 answer
Psql get table data types
SQL
0 vote190 views1 answer
Sql tablo hangi sp de
SQL