/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

4 votes359 views6 answers
Sql select statement
SQL
1 vote326 views1 answer
How to select random rows from table
SQL
12 votes331 views1 answer
How to change the value of a table in sql
SQL
34 votes339 views6 answers
Sql change data type
SQL
0 vote377 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote311 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
1 vote354 views1 answer
Sql group by sum with condition
SQL
17 votes410 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote401 views1 answer
Copy row from db to db mysql
SQL
0 vote338 views1 answer
Pl sql search in all packages
SQL