text: mysql, can you get the sum of two columns in the same row? i have two columns in my table with numeric values. the table has over 1000 rows. i want to add the two number together per row. do i need to set a varible? nope...try this... select sum(field_a + field_b) from table_name