sql 1 table and get average the rows of some columns code example Example: mysql average of multiple columns SELECT avg(col1 + col2) FROM test WHERE uid=5;