title: Different delimiter in group concat
body: <p>I have an sql query like this:-</p>
  
  <pre><code> REPLACE(
    GROUP_CONCAT( 
     IF( 
      (timediff(delta_ts,creation_ts) &gt; '03:00:00')    
       &amp;&amp; (priority='P5') ,bug_id,'')
       ),',,','' )
     AS exceeded_bugs
    from bugs
    ......
  </code></pre>
  
  <p>The result I got:-</p>
  
  <pre>
  exceeded_bugs: ,3743331,3743332,3743333
  </pre>
  
  <p>I need different delimiter since, the default delimiter of Group concat is ",". I need to separate the bugs using space or "|" or "-" symbol.</p>
  
  <p>I tried giving :-</p>
  
  <pre><code> REPLACE(
    GROUP_CONCAT( 
     IF( 
      (timediff(delta_ts,creation_ts) &gt; '05:00:00')    
      &amp;&amp; (priority='P6') ,bug_id,'')
      ) 
      ,SEPARATOR '-' ) 
     AS exceeded_bugs 
    from bugs
    .....
  </code></pre>
  
  <p>I got error:-</p>
  
  <p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SEPARATOR '-' ) as exceeded_bugs at line 1</p>
  
  <p>Please help to correct the sql syntax of group concat with a different separator.</p>