phpcodeigniterselectaveragequery-builder

Calculate average of a specific column with CodeIgniter's query builder

I want to calculate the average of a specific column (rating).

My coding attempt is giving me a syntax error in the query.

$this->db->select('*, AVG(`rating`) As avg_r');
Solution

  • Try this:

    $this->db->select('id, name, email, AVG(rating) as avg_r');