title: MySQL Search & Replace with WILDCARDS - Query
body: <p>Is it possible to perform a MySQL search and replace while honoring wildcards?</p>
  
  <p>eg:</p>
  
  <pre><code>$search = "id='%wildcard%-houselisting-rental'&gt;";
  $replace = "class='house_rentals'&gt;";
  $query = "UPDATE tables SET field = replace(field,'$search','$replace')";
  $result = mysql_query($query);
  </code></pre>
  
  <p>I appreciate any advise on the subject 
  -h</p>