title: Query to find and replace a specific text in SQL Database (All tables and All Columns)
body: <p>I have a DB with +100 tables, most tables have a column that saves a URL but with different "Column Name" and URL is different as well. e.g.</p>
  
  <p>In one table its  </p>
  
  <pre><code>usa3030.Development.com/portal/mybook/chapter1/page1/line1
  </code></pre>
  
  <p>and in another one its</p>
  
  <pre><code>usa3030.Development.com/portal/mybook/chapter1
  </code></pre>
  
  <p>and so on, but for sure each URL have "usa3030.Development.com/portal/mybook/chapter1" in them</p>
  
  <p><strong>So I want a query that Will find each column that have text within column data (with "*" I think we call wildcard)</strong></p>
  
  <pre><code>"usa3030.Development.com/portal/mybook/chapter1"
  </code></pre>
  
  <p>and replace it with</p>
  
  <pre><code>usa3030.Development.com/MyWorld/Chp1
  </code></pre>
  
  <p><strong>Answer</strong></p>
  
  <p><a href="http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm" rel="nofollow">Search Or replace Stored Procedure</a></p>