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")?

thank you!

Answer 1

You are looking for LENGTH()

Answer 2

select * from table order by length(column);

Documentation on the length() function, as well as all the other string functions, is available here.