Returning results order by string length.

Jeremy Ross · #1 (**permalink**) 03-31-03, 22:59

Hello,

I need some help to return results form a MySQL database in the order of the size of the string. Such as:

"Hello, this is one string"
"Hey, this is the next"
"Another string"

I would like them to be returned in that order also.
The field they are stored in is called words

I have searched the MySQL online manual but with now luck. Have found the lenght function but have not had any luck.

Thanks for your help,
Jeremy Ross

r937 · #2 (**permalink**) 03-31-03, 23:06

jeremy, you were so close!

select thestring
from thetable
order by length(thestring) desc

rudy
http://r937.com/

Jeremy Ross · #3 (**permalink**) 03-31-03, 23:31

Thanks for the quick reply! And its working great!

Thanks,