/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

-1 vote272 views2 answers
Mysql get day of week
SQL
1 vote226 views2 answers
Postgresql get difference in hours between two dates
SQL
0 vote233 views2 answers
Imageview setimageresource null
SQL
0 vote223 views1 answer
Uuid sqlalcomany
SQL
0 vote244 views1 answer
How to run mysql in git bash
SQL
0 vote231 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
2 votes226 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote244 views1 answer
Stored procedures example
SQL
0 vote206 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
-1 vote217 views1 answer
Sql syntax create timestamp column
SQL