Re: Dividing two columns in mysql

[Stefan Hinz]

For accuracy, you should get 36.00, not 36.43, as can be seen in this simplified example:

mysql> SELECT ROUND(SUM(51/(51+90)),2)*100;
+------------------------------+
| ROUND(SUM(51/(51+90)),2)*100 |
+------------------------------+
| 36.00 |
+------------------------------+
1 row in set (0.00 sec)

To debug, why not output GOALS and BEHINDS? I suspect your problem lies there. So, change the first line of your statement to this ...

SELECT Team, GOALS, BEHINDS, ROUND(SUM(GOALS/(GOALS+BEHINDS)),2)*100 AS ACCURACY

... and see what you get.

Stefan Hinz, MySQL Documentation, Berlin, Germany