Mysql PHP query to count field lengths

Question

I have a table with names in a given column. I need to know how many names have 1 letter, how many have 2 letters, how many have 3 letters etc up to 20 letters, broken down by another column (year born).

The output needs to be something like this:

In other words for 1900 3 people have a name that is 1-char long. 45 people's names are 2 characters long. 453 people's names are 3 chars long etc.

I know it will involve length() and count but not sure how to construct it.

Gordon Linoff · Accepted Answer · 2014-03-31 03:14:21Z

1

This is an aggregation query, but with a function for the aggregation:

select YearBorn, length(name) as len, count(*) as cnt
from table t
group by YearBorn, length(name)
order by YearBorn, length(name);

answered Mar 31, 2014 at 3:14

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql PHP query to count field lengths

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related