RE: seoparator help

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:bless1_4u@...]
Sent: Thu, 23 August 2007 11:55
To: mysql@...
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/mysql?unsub=lists@...