mysql 행 열 바꾸기 > 질문답변

select type, group_concat(name separator '|') from test group by type ;

SELECT
case when note='cat1' then value end as 'cat1',
case when note='cat2' then value end as 'cat2',
case when note='cat3' then value end as 'cat3'
FROM sandbox;