/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 vote230 views1 answer
Postgresql auto increment not working
SQL
-1 vote208 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
8 votes221 views1 answer
Script to add datafile to tablespace
SQL
4 votes219 views2 answers
Postgres update single column
SQL
0 vote213 views2 answers
Starting mysql service from mac
SQL
0 vote201 views1 answer
Oracle activate program
SQL
4 votes224 views1 answer
Create db table
SQL
0 vote164 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote207 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote215 views1 answer
View psql output in horizontal scrolling
SQL