I just realized that this does not work with integers such as 80,
so one should add a test condition:

SELECT
IF(
 ROUND( mycol ) = mycol,
 mycol,
 TRIM( TRAILING
    '.'
    FROM TRIM( TRAILING '0' FROM mycol )
   )
)

Ignatius
_________________________
----- Original Message -----
From: "Ignatius Reilly" <[EMAIL PROTECTED]>
To: "DB list PHP" <[EMAIL PROTECTED]>; "Shaun" <[EMAIL PROTECTED]>
Sent: Friday, October 03, 2003 5:27 PM
Subject: Re: [PHP-DB] Round a number


> 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 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?
> >
> > Thanks for your help
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to