If I have a column in my table that is a list of strings, how do I append a new entry into the list in the table (for all rows) after a particular item in the list? 

```
for example: 
apple, orange, peach, banana,.... 

```

So here let's say I want to append `lemon` after the entry `peach` into every row. I know for a fact that the entry 'peach' occur in every row and it occurs only once (positioning of peach in the list might differ and occurrence of other items in the list may vary). Thanks in advance! 

I tried (but didn't work)

```
UPDATE TABLE_NAME 
concat (COLUMN_NAME, 'lemon') 
where COLUMN_NAME like '%peach,%'; 

```