Jump to content

update 634 records from one column?


mackin

Recommended Posts

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?

Link to comment
https://forums.phpfreaks.com/topic/259511-update-634-records-from-one-column/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.