PHP/mysql getting average value of a table column

Question

How do you get the everage of a mysql table column?

for example:

id | name | age

0 | name1 | 20
1 | name2 | 33
2 | name3 | 18
3 | name4 | 24

I want to get the average of all the ages.

TJHeuvel · Accepted Answer · 2011-04-07 08:59:54Z

17

Mysql supports the avg function, which returns the average value.

SELECT avg(age) as average_age FROM tablename

answered Apr 7, 2011 at 8:59

TJHeuvel

12.6k4 gold badges40 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

DaDu Over a year ago

Thank you so much. didn't know it was that easy!

Headshota Over a year ago

also be aware that if you use AVG (or other aggregate functions) with more than one column you need to use GROUP BY to group records against particular column

Jacques Over a year ago

Is avg() in MySQL faster than returning the results and calculating it with PHP?

TJHeuvel Over a year ago

You'd best test this out yourself @JaccoAmersfoort Results will vary on so many levels, maybe your database server is simply faster!

Collectives™ on Stack Overflow

PHP/mysql getting average value of a table column

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related