View Single Post

  #1 (permalink)  
Old 05-12-2007
genzeryk
 
Posts: n/a
Default Q: Sorting by the sum of columns?

Hi Folks!

I'm a newbie MySQL programmer. While doing my project I have faced
following problem:

I have five columns in my table (indexed 'id' and four with numerical
values). I would like to sum the numerical values into a kind of
virtual column and sort the table accordingly to the decreasing values
of the sum (of the virual column).

I have searched in numerous tutorials and FAQs but have not found
description of even similar situation.

Please help

Best regards,

Genz

Reply With Quote