title: How to remove newline between text in MySQL?
body: <p>I have a <code>shipping_tablerate</code> table contains 1 million records. I have multiple texts in <code>suburb</code> column. Every suburb contains between the double hyphen(--) and newline. I want to remove all the new line between the suburb. 
  <br>Below is my query. That one was not working.</p>
  
  <pre><code>UPDATE  shipping_tablerate
   SET `suburb`=REPLACE(`suburb`,'\n','');
  </code></pre>
  
  <p>My current <code>suburb</code> column text is</p>
  
  <pre><code>BRISBANE--
  BRISBANE ADELAIDE STREET--
  BRISBANE CITY--
  BRISBANE GPO--
  SPRING HILL
  --
  </code></pre>
  
  <p>I want</p>
  
  <pre><code>BRISBANE--BRISBANE ADELAIDE STREET--BRISBANE CITY--BRISBANE GPO--SPRING HILL--
  </code></pre>