Query table, sort by lower number of the two located in different colums

[pioneerx01]

OK, the title is bit confusing. Lets say that I have a table with three columns (name, no1, no2) with following rows: (Mike, 5, 7), (Julie, 6, 2) and (Jack, 8, 3). Is there a query that will allow me to sort the results in such way that it will sort them by the lowest number from either no1 or no2, depending on which one is the lowest? So, the query would look at no1 and no2 and pick only the lowest one, do the same for rest of the rows and then order them by lowest resulting numbers? So the results should be:

 

(Julie, 6, 2)

(Jack, 8, 3)

(Mike, 5, 7)

 

Thanks

[iarp]

This assumes you're using MySQL

ORDER BY LEAST(no1, no2) ASC

Edited August 30, 2015 by iarp

[pioneerx01]

Oh, excellent. Works like a charm. Thanks for the help.