mysql - Dynamic column alias based on column value

Question

I want to name the column alias based on the column value in mysql. Is that possible?

Something like this;

select  
  case when answer_type = 'RB' then 
     answer_type as 'radio'
 else 
     answer_type as 'evrything_else'
 end case
from  XTable 

Answer 1

No, that's not possible in pure SQL. You'll probably have to query the data out and then process it in whatever application is executing the query.