SELECT Date(mydate),sum(price),username from shop_table where Date(mydate)>'2011-01-07' GROUP BY Date(mydate),username Because the dates include the time, I convert them into 'only date' using Date() ...