title: MySQL: Search & Replace with target having linefeeds/carriage returns?
body: <p>I'm needing to cleanup our database and need to mass replace something like this:</p>
  
  <pre><code>&lt;div class="rtecenter"&gt;&lt;br /&gt;
  &lt;font color="#990033"&gt;&lt;strong&gt;I'm so hot, I sometimes spontaneously combust.&lt;/strong&gt;&lt;/font&gt;&lt;br /&gt;
  &lt;img src="http://i476.photobucket.com/albums/rr124/redacted/coollogo_com_63811610.gif" alt="" /&gt;&lt;/div&gt;
  </code></pre>
  
  <p>(I'm simply going to remove all instances of it).</p>
  
  <p>I already know how to do a mass replace (I'm using PHPMyAdmin), however The problem is that it has CR/LF's in it so I'm not sure how to add the correct string to find in the query ... just for testing, I've tried doing searches using <code>Char(10)</code> or <code>Char(13)</code> where the new lines are but no results are ever returned, (I know they are there though).</p>
  
  <p>Anyone know?</p>