List:General Discussion« Previous MessageNext Message »
From:Gurhan Ozen Date:July 22 2002 5:39pm
Subject:Re: Surrounding Rows
View as plain text  
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