ryan king Posted January 28, 2009 Share Posted January 28, 2009 I have a column in a table called "location" in 99% of them it has information like.. "Baltimore,MD 21202" I created a new column called "zipcode" Is there a way to copy the location column to the zipcode column and filter out everything but the zipcode? Im planning on doin away with this location column but dont want to loose all the zipcodes as I need them for proximenty searches. Link to comment https://forums.phpfreaks.com/topic/142800-copying-columns-issue/ Share on other sites More sharing options...
fenway Posted January 28, 2009 Share Posted January 28, 2009 Sure, but you'll need to establish how all of them are formatted first. Link to comment https://forums.phpfreaks.com/topic/142800-copying-columns-issue/#findComment-748590 Share on other sites More sharing options...
ryan king Posted January 28, 2009 Author Share Posted January 28, 2009 good to hear! could you provide me with an example or a link to how this done? Thanks. Link to comment https://forums.phpfreaks.com/topic/142800-copying-columns-issue/#findComment-748599 Share on other sites More sharing options...
fenway Posted January 28, 2009 Share Posted January 28, 2009 Well, if they all have a space, you can find it, and select out the left and right halves... Link to comment https://forums.phpfreaks.com/topic/142800-copying-columns-issue/#findComment-748621 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.