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