Query help - alphabetical

[KevinM1]

I was wondering how I'd go about selecting and counting database entries based on how their titles are arranged alphabetically, and how to obtain the count for all the entries associated with a particular letter.  The results I'm trying to get should look something like:

 

A (15)

B (2)

C (9)

etc.

 

None of the built-in string functions jump out at me, at least not in a way that I could use them in a select query.

[ajlisowski]

SELECT LEFT(UCASE(`title`), 1) AS `letter`, count(`title`) AS `count` FROM `lunapp_project_note` GROUP BY `letter`

 

I think this should do what you want unless I misunderstood.

[ignace]

Would this work?

 

SELECT left(field,1) AS letter, count(*) AS letter_count

FROM table

GROUP BY letter

ORDER BY letter ASC

[KevinM1]

Awesome.  Thanks, guys.