I need one query that will return the count results of the entries in a specific field. For instance here are sample queries to return the counts for each profile entry:
SELECT COUNT(*) FROM `userfield` where field8='A';
SELECT COUNT(*) FROM `userfield` where field8='B';
SELECT COUNT(*) FROM `userfield` where field8='C';
etc.
What would one query be to show the counts for each field entry? I have 12 options in total.
SELECT COUNT(*) FROM `userfield` where field8='A';
SELECT COUNT(*) FROM `userfield` where field8='B';
SELECT COUNT(*) FROM `userfield` where field8='C';
etc.
What would one query be to show the counts for each field entry? I have 12 options in total.
Comment