mysql> SELECT SUM(minutes) AS total FROM worked WHERE fin='5875' AND startdate >= DATE_FORMAT(NOW(), '%Y-%m-01'); +-------+ | total | +-------+ | 150 | +-------+ 1 row in set (0.00 sec)