Efficient way to count all users by first letter of last name 1

[snowboardr]

What would be the most efficient way to count how many records there are for each last name of a user from A-Z

ie:

A: 30 users
B: 10 users
C: 22 users

select substring(clast, 1,1), count (clast) from customers group by substring(clast,1,1);

i tried this but i get an error saying:

#1305 - FUNCTION ttdb.count does not exist

Jason

[red]Army[/red] : [white]Combat Engineer[/white] : [blue]21B[/blue]

 

[r937]

try it without the space between COUNT and the parenthesis

r937.com | rudy.ca