Re: Natural order of things.

tedd wrote:

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

Never tried it mysql, but I am led to believe that sorting based on the result of the mysql SOUNDEX function may produce the results you want. Other than that, as far as I am aware there is no way to do this in MySQL without writing a stored procedure to do it. -Stut