title: Using replace in SELECT statement
body: <p>I want to remove any break tags from one of my database fields and replace it with a space.
  so I tried the following: </p>
  
  <pre><code>$select = SELECT ID, REPLACE(fieldname, "&lt;BR&gt;", " ") FROM mytable
  </code></pre>
  
  <p>but this results in an unexpected > error. I also tried <code>'&lt;BR&gt;'</code> but this just made the field name in the csv change to <code>REPLACE(fieldname, '&lt;BR&gt;', ' ')</code></p>
  
  <p>Anyone who could point me in the right direction?</p>