MySQL Return closest matches?

[Admin]

I have a column with the following values...

1
6
8
10
15
20
23
25
99
100
120

I want to search against that column and return the matches that are the closest in value to my search term.

is there any way to do this?

[sde]

how many results would you like to buffer? do you want to go above and below the number?


the only way i can think of is 2 queries.

select * from table where field>=$number order by field asc limit 5;
select * from table where field<$number order by field desc limit 5;

eh?

[Admin]

i would prefer to get the 4 that are closest to my search number, but i think doing it that way will work for now.

thanks sde.

lets wakeboard.

[sde]

cool, .. tell me when, i'll be there. my friend in murrieta just got a tower for his boat too.

[Admin]

we are gonna head to my parents place in blythe for some river time next weekend. they don't have a boat out there, but we are gonna try to ride behind the seadoos. email me if you think you can go..