title: SQL Find & Replace part of a string
body: <p>I'm trying to find certain text "catid=18" in a string, where each string is different except for this.
  I've used this query below before, except it only seems to work if you know the entire string.</p>
  
  <pre><code>update TABLE_NAME
  set FIELD_NAME = replace(FIELD_NAME, 'findthis', 'replacewiththis'); 
  </code></pre>