Hi,

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.

Thanks,
Bobby

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 =)