sonny4fn Posted March 26, 2007 Share Posted March 26, 2007 I was wondering if anyone could help me with this I am trying to average 2 columns in mysql Thanks Link to comment https://forums.phpfreaks.com/topic/44318-solved-average-of-2-columns/ Share on other sites More sharing options...
bwcc Posted March 27, 2007 Share Posted March 27, 2007 This should do what you're looking for SELECT ((AVG(`COL1`) + AVG(`COL2`)) / 2) FROM `TABLE` Link to comment https://forums.phpfreaks.com/topic/44318-solved-average-of-2-columns/#findComment-216081 Share on other sites More sharing options...
sonny4fn Posted March 28, 2007 Author Share Posted March 28, 2007 it did thanks Link to comment https://forums.phpfreaks.com/topic/44318-solved-average-of-2-columns/#findComment-216640 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.