Hello there,

How's it going today?

Does anybody please know how to sort records in a MySQL table by character size.

i.e. Select * FROM table ORDER BY .....e.t.c (something like this?)

e.g. of table now:
1. apples (6 characters)
2. oranges (7 characters)
3. pears (5 characters)

e.g. of how I'd like the data to be retrieved from the table with the smallest sized words listed first.
1. pears
2. apples
3. oranges

I hope this makes sense? I'd be grateful for any help.

Thank you,

Regards,

Jason