title: I need to find and replace \n in a mysql field
body: <p>i've got data like this:</p>
  
  <p>1 street\n2street\nmycity\nmytown</p>
  
  <p>What i want to do is replace \n with char(10) as i need a real linebreak in the db field.</p>
  
  <p>I've got:</p>
  
  <pre><code>UPDATE data set `value` = REPLACE(`value`,'\n', char(10)) WHERE `key`='shipping_address';
  </code></pre>
  
  <p>But that is not working.</p>
  
  <p>Can anyone help please?</p>