/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 vote313 views1 answer
Postgre query date
SQL
17 votes288 views6 answers
Sql select distinct
SQL
1 vote301 views1 answer
Name of today sql
SQL
6 votes283 views4 answers
Eloquent to sql with bindings
SQL
8 votes318 views4 answers
Postgresql server restart
SQL
0 vote283 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote276 views1 answer
How to save data in database in mysql node
SQL
1 vote288 views1 answer
Sql run multiple updates in one query
SQL
1 vote312 views1 answer
How to delay stored procedure execution in sql server
SQL
13 votes283 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL