Tag: MySQL

  • Fix Missing Leading Zeroes in WordPress Zip Codes

    Recently, I helped a client import a large set of addresses into a location plugin for WordPress. The import mainly went smoothly, but we noticed some issues when searching in areas with zip codes leading with one or two zeroes. The addresses weren’t coming up as they should. After examining some of the imported addresses,…