hi, i've got a "language" field which is of TYPE SET() and it has concat values of "0,1,2,4,5" where
0=english
1=chinese
2=french
3=german
4=tamil
5=thai
I would like to select this field and replace the values with the acutal language. so in this case i would get "english,chinese,french,tamil,thai"
i can use CASE WHEN if the field has a single value like M/F, Country,Nationality...and is of field TYPE enum(), varchar...
how do i go about doing this in mysql?
tks