Try the rtrim function in php
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: Shaun [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 10:12 AM
To: [EMAIL PROTECTED]
SELECT
TRIM( TRAILING
'.'
FROM TRIM( TRAILING '0' FROM mycol )
)
Ignatius
_
- Original Message -
From: Shaun [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 03, 2003 5:12 PM
Subject: [PHP-DB] Round a number
Hi,
I have a query that returns a
On Fri, 3 Oct 2003, Shaun wrote:
I have a query that returns a number from culculation in my table. It
returns say 4.00, 8.75, 0.00, 12.50 etc. How can I get MySQL to return the
number without any zeros, i.e. 4, 8.75, 0, 12.5 etc?
You can't in MySQL. At least not that I could figure out.
This should do it:
http://www.mysql.com/doc/en/Miscellaneous_functions.html
FORMAT(X,D)
Formats the number X to a format like '#,###,###.##', rounded to D decimals,
and returns the result as a string. If D is 0, the result will have no
decimal point or fractional part:
mysql SELECT