Hey guys, is there anyway to perform mathematical functions within a MySQL query. What I want to do is something like this:



I think you can probably guess what I'm trying to do, tis a voting script and I have the total of all the votes plus the number of the votes and I want to order by the average vote amount, if you get me. I've already got a value for the total (average) vote int he DB but its only to one decimal place and thus not practical for ordering (i.e there could be lots of sites that scor 9.1 for example).

Anyone got any ideas? Can this be done?

http://dev.mysql.com/doc/mysql/en/numeric-functions.html

but what you want is AVG()..which is an agregate function:

http://dev.mysql.com/doc/mysql/en/group-by-functions.html