> I need to do a search query on the columns called > > Name of business "the name of the business" > Town "Local town or city name" > Postcode " this is the same as your zip code" > Category "this is type of business ie dress shop bakers" > XY "this is the table of geo address maped by postcode" > > I need the search to give me acurate results by the above fields. > > Example: a user is searching Heywood postcode ol10 1jb and > category hotel, > We need to see the nearest hotel to that post code > and then the next nearest and so on up to 24 hotels > > > Is there way to query this in the same manner one would do it with > US zipcodes?
The only effective way to do this is with geographic coordinates (your XY, I guess). While US zip codes _generally_ increase east to west and _usually_ have a numeric difference somewhat related to their geographic distance, this isn't always true. I know of two "island" zip codes (unrelated to those that surround it) in New York State. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]