[MySQL] 가로행과 세로열 값을 모두 구분자로 묶기(GROUP_CONCAT,CONCAT_WS)
http://blog.jidolstar.com/171 SELECT IF(t.no = 1, t.no, b.area_id) area_id , IF(t.no = 1, '전체', c.name) cname , IF(c.name = b.name, '전체/그외지역', b.name) tname , a.name sname , IF(b.enabled = 'Y', 'Y', '-') enabled , GROUP_CONCAT(CONCAT_WS("->",so.name,so.contents), '|') soname FROM Area a LEFT JOIN SpotData sd ON a.area_id = sd.area_id LEFT JOIN Theme t2 ON sd.theme_id = t2.theme_id LEFT JOIN Them..