mysql> select format(3000000,0); +-------------------+ | format(3000000,0) | +-------------------+ | 3,000,000 | +-------------------+ 1 row in set (0.00 sec)
mysql> select format(3000000,2); +-------------------+ | format(3000000,2) | +-------------------+ | 3,000,000.00 | +-------------------+ 1 row in set (0.00 sec) Cheers, Andrew -----Original Message----- From: coolcoder [mailto:[EMAIL PROTECTED] Sent: Thu, 23 August 2007 11:55 To: mysql@lists.mysql.com Subject: seoparator help Was wondering if anyone could help me with this little problem I'm having. I'd like to have a comma separator after every 3 digits. E.g "3,000,000". How would i go about this? This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
