ORDER BY length of entry

Hi,
How can I order a table so the length of the entry is ordered by. See example, this table:-

Name ID
John 1
Bill 2
Graham 3
Bob 4
Jay 5

Would give something like

Name ID
Bob 4
Jay 5
Bill 2
John 1
Graham 3



thanks

 

Hi, I figured it, I used ORDER BY char_length(COLUMN_NAME)