/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 vote34 views1 answer
Base64 encode sql server
SQL
0 vote34 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote33 views1 answer
Oracle drop type
SQL
0 vote28 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
6 votes27 views3 answers
Commit in sql
SQL
0 vote29 views1 answer
How to get inserted id in sql server
SQL
0 vote29 views1 answer
Change redo log file size in mysql 5.6
SQL
1 vote24 views2 answers
End mysql command
SQL
0 vote23 views1 answer
Zsh: command not found: mysql mamp
SQL
1 vote38 views1 answer
How to get previous year from sysdate in oracle
SQL