title: Using UPDATE and REPLACE With Wildcards
body: <pre><code>UPDATE database_posts 
  SET post_content = REPLACE (post_content,'%submitted     by%%%%%', '');
  </code></pre>
  
  <p>Is it possible in SQL to perform an <code>UPDATE</code> and <code>REPLACE</code> using wildcards? I'm trying to remove the author from the post_content column, everything after/including <code>%submitted by%%%%%</code>.</p>
  
  <p>The <code>submitted by</code> value is always different. I've tried using the query above with no luck.</p>
  
  <p>Thanks!!</p>