MySQL: Select TIMEDIFF values where the difference is greater than x

Question

SELECT TIMEDIFF(start, end) AS difference

The above value would return 00:10:00 if the start and end values were 01:05:00, 01:15:00.

How can I change my SQL statement so that it only selects differences that are greater than 00:05:00?

Answer 1

WHERE TIME_TO_SEC(TIMEDIFF(start, end)) > 300