List:General Discussion« Previous MessageNext Message »
From:Gurhan Ozen Date:July 22 2002 6:42pm
Subject:Re: Surrounding Rows
View as plain text  
SELECT code FROM zip WHERE (zip > 12345-5) AND (zip < 12345+5);

Does this work out fine for you??
Note that it will work only if the zip field is integer...

Gurhan


----- Original Message -----
From: "Jan Peuker" <jan.peuker@stripped>
To: "Gurhan Ozen" <ergenekon@stripped>
Cc: <mysql@stripped>
Sent: Monday, July 22, 2002 1:53 PM
Subject: Re: Surrounding Rows


> Hi,
>
> sorry for my bad earlier explanation.
> What I want to do is, select the 10(say, a value) nearest values to a
given
> number. The easiest way would be "near 5" shows 1..10. The problem is, the
> number should affect rows, not values, because values are not unique nor
in
> order. What I want to do is a query like "SELECT code FROM zip WHERE
> zip=12345 SURROUND 5,5" or "SURROUND 10". At the moment, I create a new
> table w/ an autoincrement and do a select...insert, then I select first
the
> id and then id-5 and id+5. This a a) very slow and redundant b) afaik not
> very safe.
> Thanks a lot,
>
> jan
>
>
>
> ----- Original Message -----
> From: "Gurhan Ozen" <ergenekon@stripped>
> To: "Jan Peuker" <jan.peuker@stripped>; <mysql@stripped>
> Sent: Monday, July 22, 2002 7:39 PM
> Subject: Re: Surrounding Rows
>
>
> > Hi,
> > Can you please explain what is the algorithm here? Say you have zip code
> > 12345, do you need all rows thats have zipcodes between 12340 and 12350,
> and
> > vice versa?
> > We can't help without knowing what do you mean by "surrounding" .
> >
> > Gurhan
> >
> >
> > ----- Original Message -----
> > From: "Jan Peuker" <jan.peuker@stripped>
> > To: <mysql@stripped>
> > Sent: Monday, July 22, 2002 11:03 AM
> > Subject: Surrounding Rows
> >
> >
> > > Hi list,
> > >
> > > A nut to crack:
> > > I have a medium-sized database(about 1000 rows). The keys contain
> > > zip-address-information. Now I want to get the surrounding persons,
e.g.
> > > someone has zip 12345 I would get(now for 4 entries):
> > > +-------+----------+
> > > | 12340 | personA   |
> > > | 12345 | personB   | <-- I searched for this
> > > | 12345 | personC   |
> > > | 12347 | personD  |
> > > +-------+----------+
> > > As you see, it's no simple arithmetical question. At the moment I fill
> an
> > > temptable w/ ids and select then - is there another way?
> > >
> > > regards,
> > >
> > > jan
> > >
> > > it would be nice if my sql could execute a query. thank you ezlm.
> > >
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > >    http://www.mysql.com/manual.php   (the manual)
> > >    http://lists.mysql.com/           (the list archive)
> > >
> > > To request this thread, e-mail <mysql-thread115260@stripped>
> > > To unsubscribe, e-mail
> > <mysql-unsubscribe-ergenekon=starpower.net@stripped>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> >
>
>

Thread
Surrounding RowsJan Peuker22 Jul
  • Re: Surrounding RowsGurhan Ozen22 Jul
  • Re: Surrounding RowsJan Peuker22 Jul
    • Re: Surrounding RowsDavid Felio22 Jul
    • RE: Surrounding RowsGordon22 Jul
    • Re: Surrounding RowsDan Nelson22 Jul
  • Re: Surrounding RowsGurhan Ozen22 Jul
  • Re: Surrounding RowsJan Peuker23 Jul
    • Re: Surrounding RowsDan Nelson23 Jul