title: GROUP_CONCAT comma separator - MySQL
body: <p>I have a query where I am using <code>GROUP_CONCAT</code> and a custom separator as my results may contain commas: '----'</p>
  
  <p>This all works well, however it is still comma separated, so my output is:</p>
  
  <pre><code>Result A----,Result B----,Result C----
  </code></pre>
  
  <p>How can I make it so the output is:</p>
  
  <pre><code>Result A----Result B----Result C----
  </code></pre>
  
  <p>I thought this was the idea of a custom separator!</p>
  
  <p>Failing that, can you escape commas in your results, so I can explode in PHP by the <code>GROUP_CONCAT</code> commas?</p>