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
See Question&Answers more detail:os