+ 2

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

28th Jun 2019, 10:58 AM
Sachin Patel
Sachin Patel - avatar
2 odpowiedzi
+ 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;
29th Jun 2019, 12:17 PM
Prabhat Kumar Singh
Prabhat Kumar Singh - avatar
0
I think that should be `ORDER'. LENGTH does count but ORDER arranges it alphabetically
30th Jul 2019, 6:38 PM
Ojo Olasehinde Itunu
Ojo  Olasehinde Itunu - avatar