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. Quote 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. Quote 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. Quote 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... Quote Link to comment https://forums.phpfreaks.com/topic/142800-copying-columns-issue/#findComment-748621 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.