MYSQL select to convert numbers to million,billions format

Question

i have simple mysql query

select count(total_profit)as profit from sales_profits

i get some thing like this as result profit=25000000000. What i want is some like this profit=25,000,000,000, is there some way by which we can do it in MYSQL?

Answer 1

Try with

SELECT FORMAT(COUNT(total_profit), 0) AS profit 
FROM sales_profits