title: Convert decimal to euro currency in MYSQL
body: <p>What is the best way to select a decimal value from the mysql database and convert it to an euro currrency in the mysql selection.</p>
  
  <p>When i select  <code>"format(multiplier  * (coalesce(Invoice.rent, 0) + coalesce(Invoice.furnished, 0) + coalesce(Invoice.gwe, 0) + coalesce(Invoice.service, 0) + coalesce(Invoice.gas, 0) + coalesce(Invoice.electricity, 0) + coalesce(Invoice.water, 0) + coalesce(Invoice.heat, 0) + coalesce(Invoice.tax, 0) + coalesce(Invoice.internet_tv, 0)) - coalesce(sum(Payment.amount),0),2)"</code> </p>
  
  <p>It returns a number like this 1,000.25  i want it to be 1.000,25 what is the best way to do this in MYSQL select query?</p>