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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
