title: How to remove new line characters from data rows in mysql?
body: <p>I can loop through all of the rows in a php script and do</p>
  
  <p><code>UPDATE mytable SET title = "'.trim($row['title']).'" where id = "'.$row['id'].'";</code></p>
  
  <p>and trim can remove \n </p>
  
  <p>But I was just wondering if something same could be done in one query?</p>
  
  <pre><code> update mytable SET title = TRIM(title, '\n') where 1=1
  </code></pre>
  
  <p>will it work? I can then just execute this query without requiring to loop through!</p>
  
  <p>thanks</p>
  
  <p>(PS: I could test it but table is quite large and dont want to mess with data, so just thought if you have tested something like this before)</p>