Hi all,
Thanks very much for the advice, it gave me more than enough input to
resolve my problem!
Kind regards,
Tom Hesp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Original Message
Subject: Re: Searching for matching zipcode in a list of (ranges of)
zipcodes
Date: Wed, 14 Jan 2004 14:14:19 +0100
From: Mirza <[EMAIL PROTECTED]>
To: Tom Hesp <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Hi,
If you rewrite ranges
Tom,
Change your database so that you have an engineer table and an
engineer_zipcodes table. Each engineer can have multiple entries in the
engineer_zipcodes table.
Engineer
Engineer_id integer auto_increment primary key
Name
Address
Etc
Create index engineer1 on engineer(engineer_id)
Engineer_
