Need help with select query ...

[Anon]

Hi, I am trying to construct a single query that returns 10 results instead of having to write 10 queries that return one result.

For example, the following works if I write it 10 times with different values for "col3", but I would prefer to write it once specifying the 10 company names and get 10 results.

$query = "SELECT AVG(col1) as avg_col_1, SUM(col2) as sum_col_2 FROM tablename WHERE col3 = 'company#1'";

If it matters, I am using MySQL, appreciate any assistance.

[Anon]

I should have read about GROUP BY a little more as it solves my problem.

$query = "SELECT col3, AVG(col1) as avg_col_1, SUM(col2) as sum_col_2 FROM tablename GROUP BY col3";