replace 1,2,3,4 by field

[Paul Polin]

I am having a table with

id ---- ids
18 ---- 15,17,123,45

how can I replace ids by names from another table ?

UPDATE tb1 SET ids = REPLACE(ids, %id_from_tb2%, name_fromtb2);

to get

18 --- Paul,John,Pierre,Roger

thank you