Hi Guys,

Wondering if anybody has any tips on ordering a select by the average of two columns in mysql

For example..

Price_min Price_max
12000 14000

In my DB I insert price_min and price_max, then on my php results page I want to sort and display my results by average price.

Help very much appreciated.

Thanks guys