How to update some part of text using SQL UPDATE statment : I have a query saved in column of a table named sqlcode which is maintaining the metadata. For instance following is a query:

    select 
    id,name,address,phone,
    .......
    ......
    ,upddate 
    from bank a
    join bankreg b 
    on 
    a.id = b.id 
    where (condition)

I'm trying to update the text of query saved in metadata but i want to only update column names part of the query without making any change to select,from,joins or any other conditions. Any way of only updating column names would be helpful. I've tried using `replace` function but couldn't got desired output.
