replace set of integers with respective string values
- by Tripz
I have a query which return the output like -- 5,4,6
Where 1 = apple, 2 = mango, 3 = banana, 4 = plum, 5 = cherry, 6 = kiwi etc.
I would like to update my output as cherry,plum,kiwi instead of 5,4,6
How can I achieve that in the same select statment.
I am okay to hard code the values.
Please confirm
May be I did explain clearly
Here is the sample
SELECT fruits FROM t_fruitid where id = 7
is returning me '5,6,4' as a single row
Now I want to update this single row output as 'cherry,plum,kiwi'
How do I do this
Thanku