It isn't in one statement, but what about, after you get your zip code select * from table where zip < yourzip order by zip desc limit 5 select * from table where zip > yourzip order by zip limit 5
On Monday, July 22, 2002, at 12:53 PM, Jan Peuker wrote: > 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, David Felio Software Developer Information Network of Arkansas http://www.AccessArkansas.org --------------------------------------------------------------------- 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
