using mysl queries to produce ratios

[pushyr]

is there a way to calculate ratios within a mysql query?

for example if i have 2 columns in the same table

column A = 10
column B = 2

then the ratio is 5:1

I normally do this using php but i'd now prefer to simplify things by doing as much as i can in the query

 

[r937]

SELECT columnA
     , columnB
     , columnA/columnB AS ratio
  FROM daTable

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[pushyr]

i was more thinking of creating maybe a string to express '5:1', as opposed to a decimal ratio '5'

here's an example of why i need to do this, if...

columnB = 10
columnA = 2,

then the ratio would be expressed as '1:5', as opposed to 0.2

 

[ingresman]

any help???

 select concat("1:",1/(columnA/cColumnB)) as ratio from daTable

gives

+----------+
| ratio |
+----------+
| 1:5.0000 |
+----------+