In a jsp application I created, I had a similar problem. I defined a constant
'spread' and then searched for values of x that x>= y-spread and x<=y+spread.
I then configured the spread value from web.xml, so I could fine-tune the
spread when the application was in testing. We didn't have the actual flight
data at the time to calculate a meaningful spread. You could also have a
lopsided search range by using a top-spread and bottom-spread.
Mark
On Sunday 18 December 2005 03:06 am, Andy Pieters wrote:
> Hi all
>
> Is there any operator for mysql that behaves like "LIKE" but can act on
> numbers.
>
> Let's say I wanted to select all rows where column x has a value of ~ y
>
> How should I do this?
>
>
> With kind regards
>
>
> Andy
--
Mark Phillips
Phillips Marketing, Inc
mark@stripped
602 524-0376
480 945-9197 fax
