How to query the number of characters of a field sorted alphabetically in MySQL.

Answer 1

You can use LENGTH method to count the number of characters and the query it by using SELECT length
For Eg:-
SELECT LENGTH(firstName) FROM tableName;

Answer 2

I think that should be `ORDER'. LENGTH does count but ORDER arranges it alphabetically