MySQL query field near value in a numeric value

If you want to find the nearest value of a value, can mysql do it? For example, there is a number 12345, the database has 12340 and 12350 of these two values, then these two values need to find out.

Select Col,min (ABS (col-xxx)) Num from TB Group by Col

Having num< limits the range of differences (because ABS itself is greater than or equal to 0)

ORDER by Num limit 10;

This article from "Cloud Light Breeze Light" blog, declined reprint!

MySQL query field near value in a numeric value