Skip to content

Instantly share code, notes, and snippets.

@EpocSquadron

EpocSquadron/new_gist_file

Created August 26, 2013 15:58
Show Gist options
  • Save EpocSquadron/6343099 to your computer and use it in GitHub Desktop.
Save EpocSquadron/6343099 to your computer and use it in GitHub Desktop.
Download ZIP
SQL for left padding zipcodes that are already in the database.
Raw
new_gist_file
UPDATE `table` SET `zip` = LPAD(`zip`, 5, '0');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment