How to SELECT records if the absolute value of the difference between two values if greater than a certain number?

Question

I have two fields that are of type int lap_time_1 and lap_time_2 . Is there a mysql query to select the records whose difference (absolute value) between lap 1 and lap 2 is greater than 30?

Answer 1

This assumes lap_time_1 and lap_time_2 are two columns and the data is held on the same row.

SELECT *
FROM YourTable
WHERE ABS(lap_time_1 - lap_time_2) > 30

Answer 2

MySQL does have an absolute value (ABS) mathematical function. So you could do something like this:

SELECT *
FROM lap
WHERE ABS(lap_time_1 - lap_time_2) > 30;

Answer 3

SELECT *
FROM MyTABLE
WHERE ABS(lap_time1 - lap_time2) > 30