I need to get some stats out of our MySQL-DB and wonder if there is a faster way in doing this.
Basically I need info about user registration for any given month before including seperation by attributes.
SELECT count(*) AS c FROM `users` WHERE `date_created` LIKE '2015-10%' AND `country` = 'DE'
This would return a number for October 2015. How could I alter this statement to return results for all months within one statement?
I would also be interested in adding something like
AND confirmed = 1 as separate result.
Is this possible with just one MySQL-Statement?