[SOLVED] mysql sum of greater of two columns....?

[joel24]

Not sure if this is possible in MySQL alone, however, it will greatly help my cause if it is so I'm pursuing it.

 

Say I have a table with columns like this

 

ID

Col1

Col2

1

10

20

2

20

15

3

15

30

 

Is it possible to find the sum of the greater values of col1 and col2 in MySQL... without using php etc..?

So it would be 20 + 20 + 30...

 

Any help would be greatly appreciated!

[Hybride]

I know you can do

SELECT MAX(col1)+MAX(col2) FROM table

but not sure if that's what you want. You get the max number of column 1 and the max of column 2, then add those two together.

[joel24]

thanks, but i need it to find the higher of each column in each row.... and add that

 

so if col1 was greater than col2 in row 23 it would put col1 in the addition, and if col2 were greater than col1 in row 12 it would put col1 in the addition there.

 

anyone?!

[Ken2k7]

SELECT SUM(IF(col1>col2,col1,col2)) AS sum
FROM table;

[joel24]

ahh wow, didn't know you could use if statements in mysql

thank you!!