MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Don Read Date:October 6 2000 4:47am
Subject:RE: newbie-display results as %
View as plain text  
On 06-Oct-00 Scott M Wagner wrote:
> Hello
> I can't find info on how to display the results of arithmetic operations
> as percents rather than decimals.  

mysql> select concat((35000000 / 290000000) * 100 ,' %') as pcent;           
+---------+
| pcent   |
+---------+
| 12.07 % |
+---------+

Regards,
-- 
Don Read                                         dread@stripped
--- The problem with people who have no vices is that you can be
        sure they're going to have some pretty annoying virtues.
Thread
newbie-display results as %Scott M Wagner6 Oct
  • RE: newbie-display results as %Don Read6 Oct
Re: newbie-display results as %Scott M Wagner6 Oct