/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

26 votes123 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote132 views1 answer
Mysql get last 2 month data
SQL
19 votes124 views4 answers
Rename database in sql
SQL
0 vote124 views1 answer
Mysql query single row
SQL
0 vote126 views1 answer
Check if string is a number sql
SQL
0 vote148 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
1 vote166 views1 answer
Find size of all DB's postgres
SQL
0 vote118 views1 answer
Check duplicate values plsql
SQL
0 vote118 views1 answer
Sql insert tuple
SQL
3 votes117 views2 answers
To_char oracle
SQL