please me create mysql query use column data column name in output table:
here table:
id | name | stage ------------------- 1 | john | stage 1 2 | mark | stage 3 3 | bill | stage 2 4 | mary | stage 2 want see this: stage 1 | stage 2 | stage 3 --------------------------- john | bill | mark | mary |
this mysql query:
select case when stage = 'stage 1' name end 'stage 1', case when stage = 'stage 2' name end 'stage 2', case when stage = 'stage 3' name end 'stage 3' table1; 