title: MySQL - Thousands separator
body: <p>I would like to know if there is a way to get a thousand separator in an SQL Query ?</p>
  <p>As I'm a bit lazy, I want to build a request which can allow me to copy/paste the result to my boss without adding this separator :D</p>
  <p>The request looks like this :</p>
  <pre><code>SELECT  COALESCE(Customer, 'TOTAL') AS &quot;Customer&quot;, CONCAT( COUNT( SegmentId ) , ' bookings' ) AS &quot;Nb bookings&quot;, CONCAT( REPLACE( SUM( Price ) , '.', ',' ) , ' €' ) AS &quot;Total (€)&quot;, CONCAT( ROUND( (
  SUM( Price ) / (
  SELECT SUM( Price )
  FROM my_db
  WHERE CreationDate = CURRENT_DATE( )
  AND SegmentStatus = &quot;OK&quot; ) *100 ) , 2 ) , ' %'
  ) AS &quot;PDM&quot;
  FROM my_db
  WHERE CreationDate = CURRENT_DATE( )
  AND SegmentStatus = &quot;OK&quot;
  GROUP BY Customer
  WITH ROLLUP
  </code></pre>
  <p>Currently, the result is (table with ';' separator, sorry I didn't manage to make a table with this editor :( ) :</p>
  <pre><code>Customer;Nb bookings;Total (€);PDM
  
  cust_1;20 bookings;20000 €;10,01 %
  
  cust_2;254 bookings;17852,12 €;8,12 %
  </code></pre>
  <p>What I want is a result like that :</p>
  <pre><code>Customer;Nb bookings;Total (€);PDM
  
  cust_1;20 bookings;20 000 €;10,01 %
  
  cust_2;254 bookings;17 852,12 €;8,12 %
  </code></pre>
  <p>Is there a way to do so ?</p>
  <p>Thanks,<br />
  B</p>