RE: Help with Sum(), newbie

> not a sum of all of the firsts. What I do want is a sum of > all of the numbers in column 5 where the date is after a > certain date, column 3 has "done" in it, and the url matches > a regular expression mysql. > > How do I do that? SELECT SUM(column5) FROM readdata WHERE processdate > '2

RE: Help with Sum(), newbie

> mysql> select first, second, SUM(first) from example group by first; > +---+++ > | first | second | SUM(first) | > +---+++ > | 1 | 2 | 1 | > | 2 | 3 | 2 | > +---+++ > 2 rows in set (0.