I have a row where it has multiple columns distinguishing the number of votes a user has.

so it'll look like this:

[ user ] [ option_1 ]  [ option_2 ]  [ option_3 ]  [ option_4 ] 
 bobby........        1  .........                3   ............             7       .........          3

Is there a select syntax that allows you to choose all rows and see which column has the greatest sum value? In this example above, option_3 will be the column value I'm looking for.

SELECT SUM(option_1, option_2, option_3, option_4) WHERE user = 'bobby' ORDER BY option_1, option_2, option_3, option_4 LIMIT 1

If this is not possible , I guess I have to retreive all 4 column values, and then use Perl to pick which one is greatest.


I'm not sure how to do it in a manner which would be considered effecient... but you can run multilayered queries (selects within selects) as well as conditional logic in your queries.

Just play around, you'll get there =)