order query result by a given number

[vronsky]

I try to explain better :

TABLE NUMBERS

number

12
85
98
82
14

is there a way to do a select query and order the result by a given number in order to have a list of all the most similar numbers to that given?

ex :

$my_number = 85

result of the query :
85
82
98
14
12

Could i do with a query or have I to works then in php with arrays?

[laserlight]

If there is an ABS function to get the absolute value, perhaps you could use an ORDER BY clause along these lines:

ORDER BY ABS(number - 85)