MySQL - How to select data by string length

Question

SELECT * FROM table ORDER BY string_length(column); 

Is there a MySQL function to do this (of course instead of string_length)?

Answer 1

You are looking for CHAR_LENGTH() to get the number of characters in a string.

For multi-byte charsets LENGTH() will give you the number of bytes the string occupies, while CHAR_LENGTH() will return the number of characters.