Breaking News: Grepper is joining You.com. Read the official announcement!

mysql-split-and-join-the-values

Enrybi answered on April 6, 2022 Popularity 1/10 Helpfulness 1/10

answer mysql-split-and-join-the-values

mysql-split-and-join-the-values

Comment

You can use MySQL FIND_IN_SET() to join the tables and GROUP_CONCAT() to concat the values :

SELECT s.sno,GROUP_CONCAT(s.values) as `values` 
FROM mapping t
INNER JOIN map s ON(FIND_IN_SET(s.id,t.values))
GROUP BY s.sno
Note: You should know that this is a very bad DB structure. 
  This may lead to a lot more complicated queries and will force 
  you to over complicate things. You should Normalize your data, 
split it , and place each ID in a separate record!

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: sql

Link to this answer
Share Copy Link