title: Update Some part of a Column based on matched pattern
body: <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>