Update Some part of a Column based on matched pattern
<p>I have a configuration table where application url get stored. Application is on various server and everytime when we need to setup a new server, we need to update the values by selecting and running a while loop in sql. Scenerios is like</p>

<p>Table : Configuration
Values</p>

<pre><code>Id | key |  DefaultUrl

1  | Key1 | www.xxx.com/something1

2  | key2 | www.xxx.com/something2

3  | key3 | www.xxx.com/something3
</code></pre>

<p>There are many more keys on this pattern and some other table too. As this is a legacy software i can not change the structure.</p>

<p>Whenever i need to setup a new server then i need to replace the url part from <code>www.xxx.com</code> to <code>www.yyy.com</code>. To achieve this i do something like</p>

<ul>
<li>Write a select query on like pattern</li>
<li>Loop through the data and replace the data in every row one by one.</li>
</ul>

<p>So right now i am looking a better approach to achieve the same. Please help!</p>