/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

12 votes324 views1 answer
Psql drop column
SQL
7 votes324 views6 answers
Reset identity column in sql server
SQL
1 vote316 views1 answer
Sql Split string function
SQL
0 vote340 views2 answers
Mysql where in maintain order group_concat
SQL
2 votes319 views2 answers
How to view created temporary tables in mysql
SQL
5 votes349 views6 answers
In operator sql
SQL
0 vote353 views1 answer
Trigger vérifier stock
SQL
0 vote302 views1 answer
Update row in sqlite python
SQL
1 vote336 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote320 views1 answer
Oracle INTERVAL DAY to second to number
SQL