Order by average of two columns MYSQL???

[StuartC]

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

Stuart

[swampBoogie]

order by (price_min + price_max)/2

[PhilipToop]

I assume you just want ((price_max + price_min) / 2). Just use that in you order by.