title: MySQL Script to SET new Column Values Based on Another Columns value
body: <p>I have an existing database with an existing table and in that table I have a column called "packageno" which stands for Package Number. I have over 400 rows of database content. Each Unique row has a Package Number. But Now, I added a column called "packagedescription" which stands for the Package Description. Right now the new column is empty. But I have a legend for the package description in PHP code, for example:</p>
  
  <pre><code>if ($packageno == 1) {
   $description = 'Interior Rooms';
   }
  if (packageno == 2) { 
   $description = 'Exterior Rooms';
   }
  </code></pre>
  
  <p>Etc....</p>
  
  <p>But from the beginning, I didn't add the description. Instead, I added the package number.</p>
  
  <p>So, what I would like to do is UPDATE or SET those empty database fields in the packagedescription column, with the actual description of the package. How would I write a MySQL script to enter the description of all existing rows, using the packageno?</p>
  
  <p>I know a little MySQL but I have never done anything like this to existing rows.</p>
  
  <p>Any Help would be appreciated!</p>