just use phpmyadmin and use sql.
first do a select * from your_table where area_code = 505 (you may not have the area code stored in a seperate field so will have to use 'substring', 'like' or 'left' to extract the area code bit)
check that you get all the results back you want and no others (esp important if your area code isn't a seperate field)
then run the sql:
update your_table set area_code = 575 where area_code = 505 (or whatever 'where' clause you used above)
Hope this helps
|