MySQL ABS() Function

Return the absolute value of a number:

SELECT ABS(-243.5);

Definition and Usage

The ABS() function returns the absolute (positive) value of a number.

ABS( number)

Parameter	Description
number	Required. A numeric value

Works in:	From MySQL 4.0