Count values with the same length

Asked Jul 15 '17 at 18:04

Active Jul 15 '17 at 18:04

Viewed 33 times

I need to count all the people with the same name length in mysql table.

Ex: Andrew, Peter, Lilly, John, Jane, Anne

The result should be 5, since Andrew is the only name that's 6 characters long.

asked Jul 15 '17 at 18:04

Fim

your question is not the clear ... explain better ... with the same name lenght you 3x 4, 2x 5 and 1 x6 – ScaisEdge Jul 15 '17 at 18:07
you mean same length, but peter and jane has different length ? – Viran Malaka Jul 15 '17 at 18:09

0 Answers0