Adding Up Values From A SQL Query

Question

I have a table like this (using wordpress)

+---------+----------+------------+
| meta_id | meta_key | meta_value |
+---------+----------+------------+
|   1     |   views  |     3      |
|   2     |   blahh  |  a value   |
|   3     |   smthn  |    boo     |
|   4     |   views  |     4      |
|   5     |   views  |     5      |
|   6     |   views  |     6      |
|   7     |   views  |     7      |
|   8     |   views  |     8      |
+---------+----------+------------+

So I want to SELECT everything WHERE the meta_key = 'views' then take the number from meta_value then add up all those numbers.

I'm not sure if this is possible, if not I could use PHP to add everything up. I thought it would be interesting to know if I can add things in SQL :)

Andrew · Accepted Answer · 2009-11-08 23:30:17Z

12

Isn't it as simple as:

select sum(meta_value) from (table) where meta_key = 'views'

answered Nov 8, 2009 at 23:30

Andrew

12k12 gold badges72 silver badges86 bronze badges

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

Comments

Myles · Accepted Answer · 2009-11-08 23:31:27Z

4

You should be able to do something like SELECT SUM(meta_value) as total FROM <table name> WHERE meta_key = 'views'

answered Nov 8, 2009 at 23:31

Myles

21.6k4 gold badges31 silver badges38 bronze badges

Collectives™ on Stack Overflow

Adding Up Values From A SQL Query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related