title: UPDATE field value if contains at least this text
body: <p>I am trying to find the correct SQL query to UPDATE fields from a table that contain at least some text. My idea is something like this.</p>
  
  <pre><code>UPDATE this IN tablename WHERE fieldname = "%value%"
  </code></pre>
  
  <p>I know something is wrong but I am new to this and in need of some help. Thanks</p>