Natural order of things.

Hi gang: I posted the following question to the MySQL list, but the only answer I received thus far was a php solution (it didn't work for what I wanted). As such, maybe if I post a MySQL question to the PHP group, then I'll receive a MySQL answer -- so here goes: I'm using the following query, and it works. SELECT id, title, url_image_small FROM $dbtable WHERE type="type_title" ORDER BY title LIMIT $offset, $rowsPerPage" But, it sorts stuff like this: Basel Square 1 Basel Square 10 Basel Square 11 Basel Square 2 Basel Square 3 Basel Square 4 Basel Square 5 Basel Square 6 Basel Square 7 Basel Square 8 Basel Square 9 What do I have to change to get it (the query) to sort like this: Basel Square 1 Basel Square 2 Basel Square 3 Basel Square 4 Basel Square 5 Basel Square 6 Basel Square 7 Basel Square 8 Basel Square 9 Basel Square 10 Basel Square 11 Thanks in advance for any answers/suggestions tedd -- -------------------------------------------------------------------------------- http://sperling.com