MySQL get sum of all values ​​without sign?

Question

MySQL

There is a column "money", it has negative and positive values, it is necessary to calculate the sum of all entries, without taking into account the sign. What is the best way to do this?

Answer 1

SELECT SUM(ABS(fieldname)) FROM tablename