nearest number

[cancer10]

If you have a column, of data type = INT, with the following numbers
as separate rows.
1
3
4
5
7
10


How can you write a sql statement where you can calculate the
nearest number to any give input.
Example , if the input is 9 ? (the answer is 10)
If the input is 8 (the anwer is 7)

[Twey]

SELECT * FROM my_table ORDER BY ABS(my_column - my_input) LIMIT 1;

[cancer10]

what does ABS do?

[Twey]

abs n | n < 0     = 0 - n
      | otherwise = n