mackin Posted March 22, 2012 Share Posted March 22, 2012 Hi, I have a table that I accidentally added 100's of incorrect phone numbers - its set to Integer - the number had a space in it - so only half the number inserted. Instead of starting over - its time I learned how to update it properly. The affected ID's are 11084789 - 11085411 - and the column is called 'est_landline' at the moment those affected have the first 3 digits of the phone number - I have the correct number now in a spreadsheet - and want to know how I can UPDATE the affected ID's without damaging the rest of the Table. Any advice people? Quote Link to comment https://forums.phpfreaks.com/topic/259511-update-634-records-from-one-column/ 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.