Code Forums - View Single Post

Admin · 07-22-2004, 04:28 PM

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?

07-22-2004, 04:28 PM	#1 (permalink)
Admin $_['Your_Mom']; Join Date: May 2002 Location: Santee Posts: 627	MySQL Return closest matches? 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?