/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 vote376 views1 answer
Install mysql for fedora 34
SQL
1 vote366 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
6 votes405 views2 answers
Subtr Oracle ?
SQL
0 vote306 views1 answer
Microsoft sql server management studio clear cache
SQL
1 vote343 views1 answer
Sql only five first row
SQL
13 votes348 views4 answers
Mysql select last 10 rows
SQL
-1 vote358 views1 answer
Capitole toulouse
SQL
0 vote504 views1 answer
Php insert null mysql
SQL
0 vote466 views1 answer
How to subquey to do not load in live database in
SQL
10 votes386 views2 answers
What is database
SQL