Is there a way to take the number data in four fields and get the average of it? Like if the four fields were like:
1.2 3.0 (or just 3) 4.9 5
and I wanted to find the average (with decimal and all) can this be done?
like four fields on one record? that's just math...
select (sum(field1,field2,field3,field4)/4) from table...
Can you use the mysql AVE() function with four fields?
Probably not. It's used to calculate average among rows, not columns. Of course, I dunno. Never occured to me to try.
