/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 vote98 views7 answers
10 random questions use python and SQL
SQL
1 vote112 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote93 views1 answer
Create bdd mysql
SQL
1 vote101 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
0 vote105 views1 answer
Oracle winter time change
SQL
5 votes97 views1 answer
Mysql last day of next month
SQL
4 votes135 views1 answer
Rename stored procedure in sql server
SQL
0 vote95 views1 answer
Bitmap join index
SQL
0 vote93 views1 answer
Sql developer connect to sql server
SQL
1 vote100 views1 answer
How to update date add hours in postgresql
SQL