Select 10 rows closest to a field numeric value
===

In PHP, I've a contest question such as "How many people will participate ?". I need to select the 10 closest answers near this total participants.

I've a table called **answers** with an *ID* and *number* field.
Let's say the total participants are 100 and I want 10 results.

I need to select the 10 results where number is closest to 100. It should be above and below 100.

How could I do that ?

Thanks,

