title: create a complex variable in mysql
body: <p>I have a problem with MySQL syntax.  I have generated a table with real airplane flights and imaginary airplane flights:</p>
  
  <pre>
  Flight_ID   Imaginary
  12345678       0
  12345678       1
  12345678       1
  12345678       1
  23456789       0
  23456789       1
  23456789       1
  etc......
  </pre>
  
  <p>Imaginary flights have the same <code>Flight_ID</code> as the real flight from which they were generated.  The <code>Imaginary</code> column indicates if its a real <code>0</code> or imaginary <code>1</code> flight.</p>
  
  <p>I need to CREATE a new variable called <code>Type</code> that will indicate if it's a real flight, or option1, option2, option3......</p>
  
  <p>I can't find the right syntax to create these option1, option2, option3 modalitites.</p>