CREATE TEMPORARY TABLE `ZipTemp` ( `ZipCode` CHAR(6) DEFAULT NULL, PRIMARY KEY (`ZipCode`) ) ENGINE=MYISAM DEFAULT CHARSET=utf8; INSERT INTO ZipTemp (ZipCode) SELECT DISTINCT ZipCode FROM AreaTownZip a WHERE a.ZipLat BETWEEN 40.3146247864 AND 42.3146247864 AND a.ZipLong BETWEEN -82.7435073853 AND -80.7435073853; in North Royalton, OH