Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: PhpMySQL Replace Value?

    What is the command to replace value of all the field record in a table using phpmysql?

    I have a table called country, and there is a filed country name. Currently I have about 50 records that have various countries, I need to replace all the records country = USA


  2. #2
    Join Date
    Aug 2004
    Use the SQL option in PHPMyADMIN:

    UPDATE tblcountries SET countryField = 'USA'

    This will replace all values in your field, you can also add a where close if required

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts