Get zip codes in radius Mysql query

---

Get zip codes in radius Mysql query

---

You can get nearest zip codes in the area simply using the following mysql query instead of processing in programming language.

Lets suppose we have a table which contains the zip groups alng with the latitude and longitude.

CREATE TABLE `zip_codes` (
  `zip_code` varchar(5) NOT NULL DEFAULT '',
  `city` varchar(100) NOT NULL DEFAULT '',
  `state` char(2) NOT NULL DEFAULT '',
  `latitude` varchar(20) NOT NULL DEFAULT '',
  `longitude` varchar(20) NOT NULL DEFAULT '',
  KEY `zip_code` (`zip_code`)
)

This Table Contains the zip group list.

Query to find the zip codes within the given radius

Get zip codes in radius Mysql query in Kilometers

SELECT zip_code, ( 6371 * acos( cos( radians( $latitude ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( $longitude ) ) + sin( radians( $latitude) ) * sin( radians( latitude ) ) ) ) AS distance FROM zipcodes HAVING distance <= {$radius} ORDER BY distance;

Get zip codes in radius Mysql query in Miles

SELECT zip_code, ( 3959 * acos( cos( radians( $latitude ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( $longitude ) ) + sin( radians( $latitude) ) * sin( radians( latitude ) ) ) ) AS distance FROM zipcodes HAVING distance <= $radius ORDER BY distance;

Add Comment

📖 Read More

• 1. SQL Prevent Duplicate INSERT - MySql
• 2. Get list of MySQL user accounts
• 3. Can't connect to local MySQL server through socket '/var/mysql/mysql.sock'
• 4. MySQL Grant all privileges on database