/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 vote192 views1 answer
C# add a textbox in mysql select
SQL
0 vote185 views1 answer
Enable full text search mysql
SQL
0 vote223 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
6 votes201 views1 answer
Postgres get size of database
SQL
2 votes207 views2 answers
Sqlalchemy return id after insert
SQL
1 vote191 views1 answer
Sql delete all values in a column
SQL
-1 vote191 views2 answers
How to display top 50 rows?
SQL
0 vote212 views1 answer
Supprimer les valeur d'une table mysql
SQL
5 votes277 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
1 vote195 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL