/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 vote149 views1 answer
Postgresql comandos basicos
SQL
3 votes137 views2 answers
To_char sql
SQL
0 vote154 views1 answer
Datatables server side filter where clause
SQL
4 votes140 views3 answers
Order by value mysql
SQL
16 votes167 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote188 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote135 views1 answer
Create table employees oracle
SQL
6 votes155 views4 answers
Remove spaces sql server
SQL
8 votes164 views10 answers
Sql
SQL
6 votes163 views2 answers
Mysql timestamp to date
SQL