https://stackoverflow.com/a/10150273 how to count rows by first letter? a noob question here! I wrote this query, but the "group by" is very stupid... so, how can I correct this? SELECT COUNT(*) AS total, 'x' as test FROM contents WHERE name LIKE 'C%' from STACKOVERFLOW.COM
