Gal Gal - 4 months ago 21
MySQL Question

MySQL - How to select data by string length

SELECT * FROM table ORDER BY string_length(column);


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

hsz hsz
Answer

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.