sql: updating comma separator values -


i looking answer can directly update comma separated values without splitting comma values.

for example:

old value   new value 123     111 234     222 345     333 456     444 

current

id  value 1   123,345 2   123 3   345,456,234 

expected

id  value 1   111,333 2   111 3   333,444,222 

i have used logic of splitting comma values updating new values , @ last using coalesce club new values comma separator. since count big logic taking lots of time execution.

can please suggest me better solution this?


Comments

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

java - No use of nillable="0" in SOAP Webservice -

ubuntu - Laravel 5.2 quickstart guide gives Not Found Error -